Customize Money (M,B,K)

[BrianDH]

I am trying to format my money.  I have tried:

=If(Sum(GROSS_AMT)> 1000000000, Num(Sum(GROSS_AMT)/1000000000, '$###0B'),

If(Sum(GROSS_AMT)> 1000000, Num(Sum(GROSS_AMT)/1000000, '$###0M'),

If(Sum(GROSS_AMT)> 1000, Num(Sum(GROSS_AMT)/1000, '$###0K'),

Num(Sum(GROSS_AMT), '$###0')

)))

See image:

This does not look right

Image 2 shows what I have without formatting. 

[Kashyap_R · Accepted solution]

Hi

try selecting Measure Expression in Number formatting.

PFA in the attachment(Image).

Hope it helps

thanks

[jpenuliar]

Hope this link can help with your requirements.

https://www.axisgroup.com/data-industry-insights-blog/gbillions-and-gbillions

Regards,

JP