Numeric Value coming back as -1

Question

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 Answer

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.