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!
Solved! Go to 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.
Hi, @NRD
Try this to change to Double.
ToNumber(TRIM(Replace(Amount, ',', '')))*-1
I hope this helps!