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
Solved! Go to 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.
@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.