AnsweredAssumed Answered

convert currency string to number

Question asked by kbsitz on May 26, 2015
Latest reply on Mar 13, 2018 by vijay_kampu

Within my Workflow, I utilize a Query List action to get a set of records to obtain the values for a 'total' field and put them into a collection. Then use a For Each action.  The values are a string in currency format; ie:  $32,000.00.  I need to convert it to a number so that I can perform a calculation.

When I utilize the Convert Value action within the For Each action, I get an error: 

Value '$32,000.00' is not compatible with the selected output variable type Number (double).

 

I want to convert it to a number and keep adding it for each item within the collection to get the grand total.

 

Can someone offer some assistance?

Outcomes