Excel to Alteryx Issue

[rohit782192]

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.

[FrederikE]

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. 

[rohit782192]

Any way to handle this type.

[Deano478]

You could try setting it to a fixed decimal with one decimal place

[FrederikE]

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.). 

[alexnajm]

You could also use a Formula after reading in the data - ROUND([Field],0.1)

[rohit782192]

@Deano478  How can we do this rounding i tried but no luck.