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!
Solved! Go to Solution.
You're quite welcome! Thanks for the kudos.