missing function: round up

[matthias_prller]

Hello everybody,

I don't find a good answer to the following business case:

For example if I know I can put 60 pieces into a box (b) and someone orders 100 pieces(p), how many boxes do I need?

I have to round up (p/b) but I can't find a funtion in MII that may help me.

I tried:

round (p/b) --> bad result for values less than x.5 (round it down)

format(p/b, 0) --> same result

abs(p/b) --> it seems like this function doesn't do anything

scalemax(1,p/b) --> I don't really understand what this function is doing, but didn't work

the only solution i can think about is something with modulo (p%b) and a repeater but I think this is a bit to much for such a small problem.

Or an other solution is to pass the values to a oracle database and get the corrct result from there (something like "select function(p/b) from dual" --> I hope Oracle has a function I need)

Or is there a quicker solution in MII?

Thanks for your help.

Regards,

Matthias

[former_member201407 · Accepted solution]

Boss

What about ceiling()?

Regards

Som

[matthias_prller · Accepted solution]

thank you. That is the function I missed.

I don't know why I didn't find it.