IBP Key Figure Calculation Based on Month

[ebrahim_bhika]

Hi Experts

We have a requirement to generate a Key Figure which should be a calculation where based on the month the Key Figure should be populated by either 1 of 2 key figures. For Example the New Key figure Should be populated By key figure one if the month is January and by key figure 2 for months February to December. We know that this is possible for a key figure using the current time period as a reference with the $$PERIODIDnCU$$ operator but can it be done by referenving given monrhs for the calculation

Regards

Ebrahim

[piyush_parekh · Accepted solution]

Hi Ebrahim,

Assuming year starts from Jan in your case, you can write following logic

1. Create a key figure which will always have value 1 (Always 1 here)

2. Define CAGR logic for KF2 (IBP_CAGR(KF1,SUM,FORWARD,PASTCURRENTFUTURE,6) The last parameter is the time profile level at which the CAGR calculation restarts. Here, yearly level. Further details regarding IBP_CAGR are available below

https://help.sap.com/viewer/bf99e931b8d44aafb4e306ec3602cbdd/2105/en-US/c7f3218d10584e74bb71b76580a1...

3. You can use KF2 for further calculation for e.g. if you want to filter out Jan then write a KF definition as IF(KF2=1,1,0)

Hope this helps!!

Regards,

Piyush

[z6user · Accepted solution]

Hi Piyush

Thanks for the tips

How would you generate a KF that is always = 1

Br