Skip to Content
0
Former Member
Nov 02, 2007 at 06:07 PM

CEIL rounding in Formula for Work Center

183 Views

Hi All,

I have a requirement to round off the value to the higher integer in the formula we use in Work Center. I tried using the standard arithmetic function CEIL, but it gives an error "CEIL parameter not defined".

My current formula has ZKILO * SAP_09 / SAP_08. I want that if SAP_09 / SAP_08 is in decimal, I want to convert it into next highest integer value.

e.g: My operational quantity is 52 kg and my base qty is 5 kg, so I want the division should give me 11 instead of 10. This is because we are packing in boxes which has capacity of 5 kgs.

Thanks!