IBP Calculation with aggregation of Time Periods

[Former Member]

Hi Experts,

I'm having issues creating a simple KF Calculation showed in the next table.

Is it possible to calculate KF3 at Month Level when the base planning level of KF1 and KF2 is Technical Week?

Thanks,

[sap_km · Accepted solution]

Hi German,

You can bring the key figures from WK to MTH level by doing below calculations

KF1@MTHPRODLOC= SUM("KF1@WKPRODLOC")

KF2@MTHPRODLOC= SUM("KF2@WKPRODLOC")

Create the final key figure with below logic:

KF3@MTHPRODLOC= "KF1@MTHPRODLOC" + KF2@MTHPRODLOC

Hope it helps!!

Regards

Arif

[Former Member · Accepted solution]

Hi Arif, will try this and update you with results, thanks.

[Irmi_Kuntze]

weeks as calendar weeks or as technical weeks?

If technical weeks, you can simple create a sum calculation for your input KF's 1 and 2 on month level and do the month calculation for the target KF 3

[Former Member]

Technical weeks, I forgot to clarify.