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.
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,
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.'
Regards,
Lalaiah
are you trying to convert to integer? try converting to double.
Integers are whole numbers only.
Hi,
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
What are your options/user settings/localization set up for?
and you can confirm you are selecting the fields in a multi-field tool, using tonumber([_currentfield_]) in the formula and clicking on change type to double?
Hi Qiu,
Same warning I am receiving.
Even i tried for sie 255.0
Regards,
Lalaiah
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.