topic Formatting a Dimension for Money in App Development

Formatting a Dimension for Money

ltc — Fri, 02 Apr 2021 07:47:23 GMT

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 — Tue, 12 Feb 2019 03:39:08 GMT

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')