Stopped converting at a comma. It might be invalid

[PassION_es]

hi need help on how to fix this error:

USD Amount: -45,000 Stopped converting at a comma. It might be invalid". I tried similar case on this link- https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Stoped-converting-at-a-comma-It-might-... but it did'nt work.  Maybe needing a RegFormula but I'm still not know how to use it.   Attached is my dummy Input data in csv format. Thank you, have a nice day.

[Luke_C · Accepted solution]

Hi @PassION_es 

I presume you're trying to convert the amount to a double? Just put a formula tool before the select tool with the below formula to update the Amount field. This will remove the commas and allow the data to be converted to a double.

Replace([Amount],',','')

[PassION_es]

Thanks @Luke_C , it works correctly.

[daya2022]

Hi, can I please check how this can be done for multiple columns?

[daya2022]

Hi, can I please check how this can be done for multiple columns?

[Luke_C]

Hi @daya2022, you would use a multi-field formula tool