Stoped converting at a comma. It might be invalid

[Lalaiah]

Hi Team,

I have one column that has currency in output getting below warning. Could you please help me out .

"USD Amount: 17,576.65 Stopped converting at a comma. It might be invalid"

Regards,

Lalaiah

[Qiu]

@Lalaiah 

This is the test flow I use.

[T_Willins · Accepted solution]

Hi @Lalaiah,

See below for converting to double.  This should convert any number of decimal points.  If you need the formula to round to 2 decimals, use the formula:  Round(ToNumber(Replace([_CurrentField_],",","")),.01).  If this doesn't work, your data may require a RegEx formula.  Please provide a sample of the data so we can help.

[PassION_es]

@T_Willins hi

Your formula does not work on mine. Maybe you can check my source data in csv format and help me proceed with my workflow automation.

Please refer to the attached dummy file.