# 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)
10|10000 characters needed characters exceeded

• 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

Regards

Abhishek

10|10000 characters needed characters exceeded
• Abhishek Rai rakesh rakesh

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.

Regards

Abhishek

• 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.