How to display values in thousands in MDX icCube

Question

How to display the value for a dimension in thousands. I would like to do it like this:

FORMAT_STRING="#,,"

But the data is returning: 10000000.001 while I would expect: 10000

+3

Arthur 28 nov. '14 at 12:50

1 answer

ic3 · Answer 1 · 2014-11-28T16:08:03+0000

The format follows the format described in the FORMAT_STRING documentation :

 FORMAT_STRING="#,###" or  "#,##0" or "#,##0.0"

when specifying a format that you shouldn't use in your locale, use the separator "," for thousands and ".". for a decimal fraction.

The separators are automatically converted to your language output.

hope this helps

How to display values ​​in thousands in MDX icCube