Skip to Content

How to Calculate MAPE Error in APO DP

Hi All

I need some help from you. i have to get % result from calculate of MAPE Error.

I did the calculation through Standard formula but i didn't get exact result of which we are viewing in forecast error percentage tab. would you please let me know how to we are calculate MAPE Error percentage and is it any customizing calculation is done in background please let me inform

me. I have attached screen shot of error percentage.

Capture11.PNG (14.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Mar 30, 2016 at 09:49 AM

    Hello Rakesh

    Formula is

    MAPE=Sum of Absolute values of % Difference of Actual and Ex-Post vs actuals )/N+1

    Period12345Corrected Sales History2889408190Ex Post Forecast 471383443Diff Of Act and Ex-1975324747% diff-69.25584.9576179.5896858.2424352.00853Abs of %69.2549984.9576179.5896858.2424352.00853

    so for the above data set Sum of last Row is 344.0532 and periods are 5, MAPE = 344.0532 /6 = 57.3422



    Add comment
    10|10000 characters needed characters exceeded

    • Hello Rakesh,

      I check the old xls which had this example, its because the forecast and sales figures where generated using RAND function in xls and displayed without decimals. But the calculation formula and method is correct, what you got is correct number with the displayed figures.



  • Apr 04, 2016 at 07:30 AM

    Hello Rakesh,

    Please refer below document for calculations of forecast errors.

    Here please note that, system takes period as (n+1) and in general statistic, we use (n) period for stat error calculation.

    Please refer



    Add comment
    10|10000 characters needed characters exceeded