cancel
Showing results for 
Search instead for 
Did you mean: 

Key Figure calcuation across the time period

dagmara_morajka
Newcomer
0 Kudos
184

Dear Experts,

I have a new requirement to define a new KF in IBP that calculates the sum of all weeks from the current week to the future shown in curret week:

The base planning level is : Wek Product SoldTo.

Can you please help define the right formula for the KF2?

I'd appreciate your help. Thanks in advance!

Accepted Solutions (0)

Answers (1)

Answers (1)

Irmi_Kuntze
Product and Topic Expert
Product and Topic Expert

I think the easiest would be the IBP_CAGGR operator where you set the 3rd parameter to BACKWARD and the 4th to CURRENTFUTURE. You would get a backward aggregation that displays in every future period of your target key figure the cumulated sum of all future values starting from the point of the calculated (KF2a).
That means, in current week you would see all future from today on, in next weeks KF you would see all future values except this week, and so on.

In a separate calculation, you could than copy the value into your KF2, but with the condition that you pick only the current period, as in
KF2@PBL = IF(PERIODIDn =$$PERIODIDnCU$$, KF2a@BPL,NULL)

(Note that there are other calculation possibilities as well, e.g. first take over only the future value in a helper, than sum up to the aggregated level of Product SoldTo (without the week), and in third step you copy back down to current period.)

Yours

Irmi