Skip to Content

Time Periods in Key Figure Calculations

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Aug 24 at 02:40 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 09 at 03:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.