Formatting of Cube Views

[afullex]

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

[David Usherwood]

Try

Code: Select all

#,##0,,

[Duncan P]

Nice.

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

Code: Select all

\R#,##0,,

[afullex]

Thanks!!! Sorry for the late reply!