TM1 Forum

Posted: **Tue Oct 30, 2012 6:13 pm**

Hi there

Does anybody know what is the custom format in a cube viewer to show a million format?

For example : If I have the amount R60 000 000, I want to format the abount so that it shows R60.
I have used 0, as the format but it doesn't work? All I get is 60000.

Thanks.
Andrea

Posted: **Tue Oct 30, 2012 6:30 pm**

Try

Code: Select all

#,##0,,

Posted: **Tue Oct 30, 2012 7:13 pm**

Nice.

And after a bit of experimentation ... to get the R in front you need

Code: Select all

\R#,##0,,

Posted: **Mon Nov 05, 2012 1:50 pm**

Thanks!!! Sorry for the late reply!

TM1 Forum

Formatting of Cube Views

Formatting of Cube Views

Re: Formatting of Cube Views

Re: Formatting of Cube Views

Re: Formatting of Cube Views