Thousands separator with no digits

(4 posts) (2 voices)

Tags:

No tags yet.

  1. maron, Member

    I might be overseeing something obvious but I'm trying to format a number like this 112356 -> 112.356 - the current result is 112.356,0000

    We use . for number separator here and I don't want any extra digits.

    As soon as I apply %d in colstyle I loose the thousands separator. I've googled printf for this but found no solution I could apply.

    Kindly assist.

    Posted 3 years ago #
  2. myDBR Team, Key Master

    If you use integer numbers your default format is 112.356 (if you have "." as thousand separator). How do you get the 112.356,0000?

    --
    myDBR Team

    Posted 3 years ago #
  3. maron, Member

    Yes - the problem is that these are decimals in our database, I could of course round them off in the query or cast them to integer but it would be better in our case to just have the default format of decimals without extra digits. This is a problem in nearly all our reports.

    Posted 3 years ago #
  4. myDBR Team, Key Master

    Decimal nunbers are by default shown as a decimal number. You can format a column with '%.0f' which will hide the decimals and still keep the thousand separator.

    --
    myDBR Team

    Posted 3 years ago #

Reply

You must log in to post.