How to Calculate MAPE Error in APO DP

[Former Member]

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.

[former_member225716]

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

http://scn.sap.com/docs/DOC39791

regards,

Sachin

[former_member244427]

Hello Rakesh

Formula is

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

Period	1	2	3	4	5
Corrected Sales History	28	89	40	81	90
Ex Post Forecast	47	13	8	34	43
Diff Of Act and Ex	-19	75	32	47	47
% diff	-69.255	84.95761	79.58968	58.24243	52.00853
Abs of %	69.25499	84.95761	79.58968	58.24243	52.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

[Former Member]

Hi Abhishek Raj

Thanks to given update for MAPE Calculation

but i have small doubt when i calculate the %diff value it's gives different values to me.

Ex: i have calculate the your values  -19/28*100 = -67.857 but your calculation shows me -69.255.

I have calculated based on your  MAPE Calculation i was get the error result 2% different  of actual result, will you please tell me how your are calculated %diff value.

Thanks

Rakesh

[former_member244427]

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