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.'
are you trying to convert to integer? try converting to double.
Integers are whole numbers only.
I tried both
Warnings:
For Double: " ConvError: Select (27): USD Amount: ########### is not a valid number."
For Intgr : "ConvError: Select (27): USD Amount: 532.38 lost information in translation"
For Fixed Decimal: "ConvError: Select (27): USD Amount: "2513.10" has too many digits after the decimal and was truncated."
Regards
Hi Qiu,
Same warning I am receiving.
Even i tried for sie 255.0
use the multi-field tool with the options I discussed above. If that doesn't work can you post more numbers? and it may be time for THE REGEX SOLUTION.
@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.
