Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Rounding Numbers Confusion

Anant_Basant
5 - Atom

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.

 

1 REPLY 1
apathetichell
20 - Arcturus

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.

Labels
Top Solution Authors