Money format pattern not producing expected result

[mrmatt]

Hello,

I have a number which defaults like this: 100260943.07 which I want to  format as a currency. I used a custom format of this: $#,##0.00 and the result was this:  $100260943,##0.00. However my expected/desired result is this:  $100,260,943.07.

What am I doing wrong and/or how do I modify the format to obtain my desired result?

thanks,

[treysmithdev]

Try: '$#,##0.00;-$#,##0.00'

[mrmatt]

@treysmithdev thanks for trying but it also gave me $100260943,##0.00

[treysmithdev]

Can you please share your expression.

Also, check your localization variables, the generated variable statements in script editor.

[mrmatt]

@treysmithdev thank you. My expression is simply Sum([Actual'18]). I'm using "Money" in the Number formatting and my Format Pattern is $#,##0.00;-$#,##0.00.

[Anil_Babu_Samineni]

If you have other few values which are different than original, Share them as well. You can try?

Num(100260943.07, '$###,###,###.##')

[mrmatt]

perhaps these screenshots will help, I'm sure it's simple but I haven't been able to get it yet:

[y_grynechko]

Just to make sure, does the above set up fail for you to work? 

[StarinieriG]

Hi

try to set the variable like this

SET MoneyFormat= '$#,##0.00;-$#,##0.00';

[mrmatt]

@y_grynechko yes, that's exactly what I have and it's not working. Any ideas why?