cancel
Showing results for 
Search instead for 
Did you mean: 

Time Periods in Key Figure Calculations

0 Kudos

Dear Experts,

I am trying to understand one simple key figure calculation.As my requirement is to calculate Projected DOS which is a calculation of KF1/KF2, where

KF1 = Previous bucket

KF2 = Avg( Current week + 12 week KF2)/7

Thanks,

Divya

Accepted Solutions (0)

Answers (2)

Answers (2)

ankpatel
Contributor
0 Kudos

Hi Divya,

What is your exact requirement/issue? If possible please share the example in an excel screenshot, so it is easy to understand what you are looking for?

Regards

Ankur

0 Kudos

Hello,

Can someone please help me with logic for average of current week+12 weeks of a key figure?

KF1@WKPRODLOC = Avg( current week + 12 weeks of KF2@WKPRODLOC)

Thanks in advance