Hi Team,
In Excel i have a value as 33.3 but when input in Alteryx i am getting as 33.29999997.
I am unable to trace the issue for the same.
This has something to do with how your computer stores Data. With too many digits your computer loses precision in how to store it (since there is only 1 and 0 to keep it).
Alteryx shows the Actual Values and how they are stored. Excel always does some automatic rounding.
Any way to handle this type.
You could try setting it to a fixed decimal with one decimal place
Hey @rohit782192,
There is no real way to fix this since Alteryx is reading only the memory of your Computer - Excel is doing something other than just reading the data.
You can use what @Deano478 mentioned to make Alteryx do what excel does - always rounding to a certain degree - but that is kind of "covering" the issue (which should be totally fine ofc.).
You could also use a Formula after reading in the data - ROUND([Field],0.1)
@Deano478 How can we do this rounding i tried but no luck.
