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.
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
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.
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
You must log in to post.