SAP IBP Formula similar to excel CEILING function

4 months ago 28

Hi all,

I person been searching for answers connected this one, but couldn't find any. Perhaps one volition onslaught immoderate luck here.

I request to cipher a CEILING betwixt 2 antithetic inputs, for illustration a KF and an integer attribute:

KF_A: 100  

Attribute_B: 15 -> The aggregate to which KF_A volition beryllium rounded

-> The look should effect successful 105 which is the KF_A rounded up to the nearest aggregate of Attribute B

There is CEIL IBP formula, but it lone allows for 1 input, truthful not usable successful this case..

There is an MS Excel look that works perfectly: https://support.microsoft.com/en-au/Key Figure Formulaoffice/ceiling-function-0a5cd7c8-0720-4f0a-bd2... 

Any assistance volition beryllium greatly appreciated.

Thanks! Andrei

Read Entire Article