cancel
Showing results for 
Search instead for 
Did you mean: 

CEIL rounding in Formula for Work Center

Former Member
0 Kudos

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!

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I could get the solution using the standard operands.

Former Member
0 Kudos

Could you show us the complete syntax you use for the CEIL Function?

Former Member
0 Kudos

Hey Mike,

Like I explained in the email, the current work center formula is

ZKILO * SAP_09/ SAP_08

hence I want to use the CEIL formula as below:

ZKILO * CEIL ( SAP_09 / SAP_08).

Hope this helps to clarify my problem.

Former Member
0 Kudos

First, only the following operations are allowed in formula

Arithmetic functions

+, -,*,/

Trigonometric functions

SIN, COS

Integral division

DIV, MOD

Square root

SQRT

Exponential function

EXP

Natural logarithm

LOG

see the help file link-http://help.sap.com/saphelp_47x200/helpdata/en/b1/c03e4a439a11d189410000e829fbbd/frameset.htm

Hence you cannot use CEIL in formula

but whatever you are asking can be done using CAPP...see the help file

http://help.sap.com/saphelp_47x200/helpdata/en/01/d542654ab311d189740000e8322d00/frameset.htm

please try come back

Former Member
0 Kudos

Hi Rajesh,

I could achieve my requirement by playing around with standard operands:

ZKILO * ( ( SAP_09 - 1 ) DIV SAP_08 + 1 )

Thanks!

Former Member
0 Kudos

that is great,,,if ok with you reword and close the subject.

Former Member
0 Kudos

Better to use a fixed lot size so that system will create a different planned order for 5 kg, if it is less than 5 kg, system will still create a seperate planned order for extar qty in you case 2 kg.

Former Member
0 Kudos

Hi,

The requirement is to create one process order and then while doing the confirmation round-up the number of boxes used.