Formatting a Dimension for Money

[ltc]

I have a dimension field that I'm formatting for money as follows:

=Money([Amount]/1000000)

So that's turning $10,333,333 into $10.33, but I need to see three decimal places to the right to show $10.333.  How do I do that?

[ryo_okabe · Accepted solution]

Hi,

There are two ways to change money format.

1.Change [MoneyFormat] in data load editor.  This affect all money format.

2.Change dimention to follows.This will only affect this dimension.

    =money([Amount]/1000000,'$#,##0.000;-$#,##0.000')