comma and decimals formatting issue

[jboschee]

Hi everyone,

I'm having some issues formatting numbers.  Here is what I've tried so far.

regex_replace([GROSS_SALES],"\d{1,3}(?=(\d{3})+(?!\d))","$&,")

This seems to work for gross sales, but when I do the same formula for net sales I get something like this:

0.0,000,000,000

'$'+TOSTRING([GROSS SALES]/[Budget Rate],2,1)

This worked for my conversion to USD as long as the number of local currency is set as a fixed decimal.  If the local currency is string, it doesn't work.

If I try the 2nd formula for the gross and net sales in local currency, the comma's are missing.

Any help is greatly appreciated.

Thanks in advance!

[MarqueeCrew]

You're quite welcome!  Thanks for the kudos.