Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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')
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')