Key Figure Calculation - using Total as formula

[vitor_camargo1]

Hi Experts,

We have a business scenario in that IBP should calculate dynamically the actual qty proportionality (in percentage) of a certain location in the whole state (an aggregate attribution of location) or even for products in the same product family.

Example 1:

Example 2:

I was thinking if it's possible to use a kind of total function or even use aggregation between the planning levels to replicate this logic using only one key figure.

[manikandan_shanmugam3]

Hi Vitor,

It won't be possible to acieve it through one keyfigure however you can use couple of helper kf to achieve it, still its one calculated keyfigure.

HKF 1 = Perform forward rolling aggregation at - Product Family, Product , Location level

HKF2 = Perform forward rolling aggregation at - Product Family, Product level

Calc KF= HKF/HKF2

Regards,

Manikandan

[AyanBishnu]

Hi vitor.camargo

Assuming that your KF1 and acutaly qty KF are both at the same planning level (e,g PL0), you can do the following.

Create a planning level PL1 with (PRD, state as root)

Create a planning level PL2 with (PRDFAMILY and State as root)

create a new KF(e.g KF2) at the same planning level as actual qty(e.g PL0) and use the below calculation level

• KF2@PL0= actualy qty @PL0
• KF2@PL1= SUM(KF2@PL0)
• KF2@PL2=SUM(KF2@PL1)
• Actual qty@request = SUM(actualqty@PL0)
• Now in your KF1 use the following
• KF1@PL0= (100 / Actulaqty@PL0 * KF2@PL0)
• KF1@PL1= (100 / Actulaqty@PL1 * KF2@PL1)
• KF1@PL2= (100 / Actulaqty@PL2 * KF2@PL2)
• KF1@REQ= (100 / Actulaqty@REQ * KF2@REQ)