Auto currency change in Number formatting

[DJ55]

Hi Everyone,

I am trying to use number formatting as Money. I have updated the money format to "$#,##0M;-$#,##0M"but values which are not in Millions are reflecting as $0M. These values are in Ks.

Is there any way where I can show values in Millions as well as in Ks. 

I can not use auto number formatting because "$" sign will not reflect in it.

[Or]

As far as I know, if you want the format to be dynamic, you need to use the auto formatting.

You could instead format using if() statements, e.g.

Money(Value,If(fabs(Value) >= 1000000,'$#,##0M;-$#,##0M','$#,##0K;-$#,##0K')

[DJ55]

Thank you.
But where can we enter this expression . Do I need to put it in Measure or in Formatting?

[Or]

This would be in your measure (and you would then keep the formatting on expression default, or whatever it's called, I forget)

[DJ55]

It is measure expression format type. Thank you I will try this.

[DJ55]

Hi 
I was trying using this expression but below error is popping up

Error in expression: ')' expected 

This is the expression I used

Money({'$(Total Spend)'},If(fabs({'$(Total Spend)'})>=1000000,'$#,##0M;-$#,##0M','$#,##0K;-$#,##0K'))

Total spend is the variable I have created

Total Spend= Sum(value)/1000000

Can anyone help with what I am missing in this expression?