0 Replies Latest reply: Aug 30, 2013 7:13 PM by 986975 RSS

    Time based KPI Calculation

    986975

      Hi All,

       

      I need to define a report where I need to calculate Supply - Demand for the complete horizon.

       

      Following is the example: -

       

      Week #                                     1               2               3                4             5                 6             7

       

      Sales Orders                                                            100                           150                             120

       

      Supply                                    500                                                                                400

       

      Projected Supply                     500             500        400               400        250                650          130

       

      How to calculate the value of ''Projected Supply'?

       

      Projected Supply = Projected Supply from Previous Week + Supply From Current Week - Sales Orders from Current Week

       

      Appreciate help on how to calculate this time dependent KPI.

       

      Regards,