IBP KF calculation between planning level

[OliverA41]

Hello,

I have a question about the calculation of a kf between to different planning levels.

I have a budget quantity with Euro as currency. it is on the level MTHPRODLOCCUSTCURR. With a planned price on the same level should calcualte a quantity of pieces on the level MTHPRODLOCCUST. with UOM in EA

e.g.

BUDGET@MTHPRODLOCCUSTCURR (€)/ PlannedPrice@MTHPRODLOCCUSTCURR (€) = Quantity@MTHPRODLOCCUST (EA)

How can I do this ?

Thanks in advance

Oliver

[Praveen_Jadhav · Accepted solution]

Hi Oliver,

Maybe there is a simpler solution, but this is what I propose:

1. Create 2 additional KF let say ZBUDGET@MthProdLocCust and ZPPRICE@MthProdLocCust.

2. Use Copy and Disagg. operator source as your original Budget and Planned price; destination both new Z key figure, using attribute1=Prod; attribute2= Loc; attribute3= Cust; Periodname= Mth; filter as currid=Euro. copy the data.

3. now all 3 KFs (Zbudget, Zpprice, Quantity) are at the same level i.e. MthProdLocCust. Now write a calculation:

Quantity@MTHPRODLOCCUST = ZBUDGET@MTHPRODLOCCUST / ZPprice@MTHPRODLOCCUST

Hope it works.

Regards,

Praveen

[former_member654033]

Hi Oliver,

Can you try below.

Create Qty KF at MTHPRODLOCCUST (Base Planning level) and write below calculation (only Request level Calculation)

Qty@Request = Budget KF@Request / Price KF@Request

Please check if this works

Thanks

Girish

[lingaiahvanam]

Hi,

Check the following calculation.

SH1DPBUDGETCOST@REQUEST = SUM(SH1DPBUDGETCOST@WKPRODLOCCUSTCURR)

SH1DPBUDGETCOST@WKPRODLOCCUSTCURR = COSTPERUNIT@WKPRODLOCCURR * SH1DPBUDGET@WKPRODLOCCUST

SH1DPBUDGETCOST@WKPRODLOCCUSTCURRCURRTO = EXCHANGERATE@MTHCURRCURRTO * SH1DPBUDGETCOST@WKPRODLOCCUSTCURR

Best Regards,
Lingaiah

[OliverA41]

Hello Lingaiah,

thanks for the response.

But unfortunatley, it is not success because for my understanding is your solution not what I am need.

I have a price and I have a budget (annual sales). I want to calculate the quantity

So I need a calculation like this

Quantity@MTHPRODLOCCUST = BUDGET@MTHPRODLOCCUSTCURR / PlannedPrice@MTHPRODLOCCUSTCURR

quantity are in piece

BUDGET and Planned price are in EURO