Rounding decimal issues, truncation

[ZahinOsman]

Hi Guys,

I'm trying to run some calculations through Alteryx. The data is taken from excel, but the issue is that Alteryx does not store the full decimal place for the value I'm trying to use

Eg.

1.36248049999979 (in excel) is read as 1.362480500000 (Alteryx). I have tried changing data type to Fixed Decimal 19.14 to account for all the decimal places but its not working. 

To provide context, I'm trying to sum a lot of these similar types of values together but there is a difference when I perform this in excel vs when I sum it through alteryx. I'm aware of the issue between how excel stores data vs how Alteryx stores data, but just hoping someone has figured out a workaround for this

Best regards,

Z

[Qiu]

@ZahinOsman 
I think I was able to input the data without loss with Fixed Decimal data type.

[ZahinOsman]

@Qiu Thanks but I am also multiplying this with another FixedDecimal value using a formula tool

eg. 100,000 x 1.36248049999979 

I have thousands of these running simultaneously, it seems that after using a formula tool, 1.36248049999979 will change to 1.362480500000

[Qiu]

@ZahinOsman 
I think we could all agree that there is a size limitation for any tool.

I tried below and understands that the maximum precision is 50, inclusive of the decimal point and negative sign (if applicable).

[PangHC]

@Qiu i searched years ago where Alteryx rounding and excel rounding is different. but i cant find the resource link. 

since majority of my company are validate report in excel, then I using the double and avoid use fixed decimal.

Copilot answer (i asked source, but it not provide any)

Spoiler

here the test i made. 0-10 with increment of 0.01, but the only different only 3 rows:

[apathetichell]

100,000 x 1.36248049999979 is greater than 19.14 and would round--- at a minimum that should be something like 21.14