Numeric Value coming back as -1

[NRD]

Good Afternoon,

I have a potential data type issue. When I bring this "Amount" field through my Alteryx process as a string I have the complete value for each of my records. The record indicated below in red changes to -1 when I update the data type to be a "double" and multiply the whole data set by -1m as shown in my second screenshot. Any clue why this is? All I want to do is multiply all records by -1. Thanks!

[markcurry · Accepted solution]

I think this is because those values have a comma in them, so if you use the Replace formula beforehand to replace the comma with nothing, it should hopefully fix the issue for you.

[RobertOdera]

Hi, @NRD 

Try this to change to Double.

ToNumber(TRIM(Replace(Amount, ',', '')))*-1

I hope this helps!