1. D

    WMAPE formula Help

    Hello <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> Does anyone know a formula to calculate WMAPE – Weighted Mean Absolute Percentage Error? I am currently using the MAPE measure however I am told Weighting the error would give me a more...
  2. A

    edit a calculated field from a pivot table

    Hello, I have a pivot table which I have created a calculated field called WMAPE which stands for Weighted Mean Absolute Precent Error. The formula looks like this. =IF(AND(SUM(Actual)=0,SUM(Forecast)=0),0,IF( SUM(Actual)=0,100,'Abs Error'/Actual)) The first IF is checking to see if a...

Some videos you may like

This Week's Hot Topics