I have the Price column (V_String) with different currency formats as below. I want to add decimals and make them all the same (i.e: $1234.00).
I tried ToString([Price],2,1) and also IF Contains([Price], ".") THEN [Price] ELSE ([Price] + ".00") ENDIF but they did nothing.
Does anyone know how to do this? Thank you in advance!
Solved! Go to Solution.
Slightly change your expression to the following will do the trick.
IF Contains([Price], ".")=-1 THEN [Price] ELSE ([Price] + ".00")