Hi everyone,
I'm getting this error when doing a currency conversion. Below is the formula I'm using for the conversion.
'$'+TOSTRING(TONUMBER([GROSS SALES])/TONUMBER([Budget Rate]),2,1,".")
In my export, it is returning $1,703.56 when it should be $1,074,245.05
Any help is greatly appreciated.
Thanks!
Solved! Go to Solution.
If you have commas in your [GROSS SALES] and [Budget Rate] columns, those will need to be removed for the calculation. Try this:
'$'+TOSTRING(TONUMBER(replace([GROSS SALES],",",""))/TONUMBER(replace([Budget Rate],",","")),2,1,".")
Unfortunately, it didn't work. Still getting the error and having the calculation cut off.
Take a look at my attached solution. It runs with no conversion errors for me. Please let me know if this helps.
Thanks for all the help Charlie. I received zero values for all converted to USD values. I attached a picture of the workflow I'm working with. #1 - with your formatting and #2 is with your conversion formula
WebEx is wonderful.
ToString([My Number], 2, 1, ".")Where [My Number] is a number and 2 is the # of desired decimal places and 1 says that you've got thousand "characters" and that your decimal is a dot.
All worked wonderfully.
Cheers,
Mark