Time Periods in Key Figure Calculations

[former_member752811]

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

[ankpatel]

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

[former_member752811]

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