I have a measure that show number in millions / billions.
The formatting of the number for now is like this : "$#,##0.0;-$#,##0.0"
I would like to format the number to show something like this:
If the Orginal number is: 117,100,000 $
I want to see it like that: 117.1 M $.
Can we do it on SSAS cube?
Thanks.
Best Answer
Please try this format string:
This trick is a bit buried in the documentation.