CEIL function not return expected value

[ThuNguyenPhuoc]

Hi there,

In my data, Incentive contains 18 rows with value 98337591.89 and 1 row with value 98337591.98 when I do the summary it resulted Amount = 1868414246, but when I do CEIL(Amount) it provides 1868414247, datatype is Double. Any one can help?

Thank you.

[binuacs]

@ThuNguyenPhuoc I am getting the same amount after applying the ceil function, are you seeing this difference after connecting to the summary tool? did you apply the ceil formula before summary tool and see the same result is coming or not. also what version of alteryx are you using?

[apathetichell · Accepted solution]

Don't use Double ---> use Fixed Decimals like for 19.6 or something. Double is stored as a fraction in memory. This is imprecise and can create continuity issues at large numbers/tiny numbers or with lots of instances.

[ThuNguyenPhuoc]

Hi @binuacs,

I can't apply CEIL before Summary since the result will be totally different. I'm using version 2023.1.1.306.

[ThuNguyenPhuoc]

Hi @apathetichell, changing to FixDecimals work for me. Thank you.