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
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.
before the select tool try using a formula tool that says
Replace([USD Amount], ",", "")
That will remove the comma and allow for you to change the data type to a number.
Hi @Lalaiah.
Exactly what @BrandonB said but you will need to use a Multi-Field Formula tool instead of a regular Formula tool to change the field type without changing the field name.
Hi,
Thank you for your quick response
. It's working fine but again getting a new warning as 'ConvError: Select (27): USD Amount: "532.38" has too many digits after the decimal and was truncated.'
@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.
