Key figure division formula with INTEGER value result

[maurizio-gibbin]

In IBP I created a custom KF and the calculation is a division of which I would like to use the result as an INTEGER value (therefore without decimals).

Alternatively, how can I save the value of the remainder value of the division (rest)?

Has anyone already solved this problem and would you kindly know how to help me?

Thank you in advance

Maurizio

[maurizio-gibbin]

Hello Raghunath,

thank you for your support.

Suggestions successfully applied.

Have a nice week.

Best regards

Maurizio

[raghunathpartha]

Hello maurizio_gibbin

Alternatively you can use MOD Operator to get reminder. For eg : 54/5 - Integer - 10, Remainder - 4.

If you want to capture 4 in separate KF, then you can use - kf3@wkprodloc = kf2@wkprodloc % "Demoninator (No or another KF).

For eg:

"KF@WKPRODLOC"%5 - In this case it will return 54/5 - 4 as value in KF.

[guglanigaurav1987]

Hi Maurizio,

You can use 'FLOOR' or ROUND functions to get the integer value of the calculation.

To get the value after decimals, you can use the 'FLOOR' function to save the result in the intermediary Key figure and then take the difference of the original KF with the intermediary one.

See the help document below for the configuration assistance on these functions.

https://help.sap.com/docs/SAP_INTEGRATED_BUSINESS_PLANNING/bf99e931b8d44aafb4e306ec3602cbdd/b8582c55...

Hope this helps!

Regards

Gaurav

[maurizio-gibbin]

Thanks so much Gaurav, I'll try right away.

Have a nice day.

Maurizio