I saw some answers already however did not find anything concrete so asking a new question.
I have a field where values are in USD, like $123,4.00.
I want to run addcoltotals on the field, and bring back the currency sign and commas once the operation is done.
I got rid of currency sign and commas using following:
| replace "$" with "" in | replace "," with ** in
Not sure if I need to use replace twice, using a comma didnt work for me so using replace command twice.
Now which would be the best way to get rid of $ and , signs and add the numbers. And then bring back those signs again.
... View more