CEIL function not return expected value

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.

Output

Accepted answers

apathetichell

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.

All comments

binu_acs

@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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703