Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Round to nearest multiple

ayadav8
8 - Asteroid

Hey,

 

I need to update "Recommended Order" which is a round up number of "order" quantity to the nearest multiple of "carton qty". Attached is an example of the scenario.  and "Recommended order" need to be always higher than "Order" quantity.

 

Thank you!

 

 

3 REPLIES 3
jrgo
14 - Magnetar
= ROUND(([Order]/[Carton qty]) + 0.4) * [Carton qty]

Should do the trick!

***minor edit in case the division is a whole number***
jrgo
14 - Magnetar
Ceiling function would actually be more appropriate as I think of it.

CEIL([Order]/[Carton qty]) * [Carton qty]
ayadav8
8 - Asteroid

Thanks @jrgo. the logic works.

Labels