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!
