3 Replies Latest reply: Jun 10, 2016 1:02 AM by Prasenjit Gupta RSS

    Displaying KPIs for Forecast Variance

    Prasenjit Gupta

      I have the following sample dataset.

       

      DateForecasted ValueActual ValueDifferenceMod(Difference)Mod(Difference)/Forecasted Value as %
      1-Jan-16111101091%
      2-Jan-161028880%
      3-Jan-16936667%
      4-Jan-16844450%
      5-Jan-16752229%
      6-Jan-1666000%
      7-Jan-1657-2240%
      8-Jan-1648-44100%
      9-Jan-1639-66200%
      10-Jan-16210-88400%
      11-Jan-16111-10101000%
      Sum6666060

       

      I want to include the following calculation results as KPIs (Please review the attached excel for complete formula details)

      Overall % Variance calculated based on Sum(Mod(Variance)) / Sum(Forecasted Value) - 90.91%

      Average % Variance calculated based on Average(Sum(Mod(Difference)/Forecasted Value)) - 186.92%


      What should be the calculation for displaying the above values as KPIs?

      Thanks in advance.