Rounding Numbers Confusion

[Anant_Basant]

I am confused with the Ceil() function. If you look at the documentation and a result from Alteryx they don't seem to match.

Please have a close look at the documentation image (img1.png) and another image from Alteryx (img2.png). May be I am wrong, but I want to understand what is going on in these two images.

[apathetichell · Accepted solution]

What's your issue in img2? the negative numbers seem to be rounded up as per the documentation (ie -109 would round up to -100)... If you are looking for an absolute value round - you'd have to multiply the ceil of abs of negative numbers by -1.