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?