Key figure calculation with period past, current and future

[former_member267321]

Hi Team,

I have a requirement to create new calculated key figure which will have values from three different stored key figures.

Ex. Stored key figures are- Actuals Qty, Open Order qty, Forecast Qty

Now, new key figure should show "Actuals Qty" for Past months, "Open Order Qty" for current month and "Forecast Qty" for future months.

Could you please help how to define calculation logic for this?

Regards,

Kiran

[AyanBishnu · Accepted solution]

Hi Kiran

Below is the expresssion that will exactly work for you. Just change the KFID, PERIODNO and planning level as per your system

NEW KF@MTHPRODLOC=

IF("PeriodID3" < "$$PERIODID3CU$$","Actuals Qty KF@MTHPRODLOC",IF("PeriodID3" = "$$PERIODID3CU$$","Open Order qty KF@MTHPRODLOC","Forecast Qty KF@MTHPRODLOC"))

Let me know if you have any issues.

Regards

Ayan

[lokesh_reddy4]

Hi Kiran,

You can try this,

KF1@LEVEL= IF("PeriodID"="$$PERIODID3CU$$","OPENSALESORDERS@LEVEL","KF1@LEVEL")

KF2@LEVEL=IF("PeriodID"<"$$PERIODID3CU$$","ACTUALSALES@LEVEL","KF2@LEVEL")

KF3@LEVEL=IF("PeriodID">"$$PERIODID3CU$$","FORECAST@LEVEL","KF3@LEVEL")

KF4@LEVEL= "KF1@LEVEL" + "KF2@LEVEL" + "KF3@LEVEL"

-->KF1,KF2 and KF3 are both stored and calculated

-->KF4 is calculated

Regards,

Lokesh Reddy