Conversion Error

[Marianne]

What does this conversion error mean ? and how to correct it ?

THANKS

[Emil_Kos]

Hi @Marianne,

Propably you have some characters in your data. Maybe you got , instead of . as a decimal place?

If you can share a screenshot of one line of data that should be sufficient to identify where the issue is.  

[Luke_C]

Hi @Marianne 

Based on the screenshot you're setting the Net Invoice Qty field to be a numeric field. But because there are parenthesis in some of the numbers alteryx doesn't recognize them as numbers (i.e. it doesn't know (4) is -4). 

There are a few good options in this thread to clean the data up:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/REMOVE-PARENTHESIS-AND-REPLACED-IT-INT...