vMAPE Calculation Help - Expression

sona_sa — Wed, 27 Aug 2014 13:16:57 GMT

Hi,

I have a scenario like this:

Please find the attached qvw.

1 Combo Chart is Calculation is simple - Sum(Sales_Qty) = Actual

Sum(SOP_CTS) = Plan

Sum(Sales_Qty) - Sum(SOP_CTS) = vMAPE

This chart is displaying the data as 'per CATAGORY wise.

2nd Char is Group Level - MEELES is a group, where these are the Categories lies (stand alone). Total no. of category is 6 which belong to MEELES.

Down side graph I need vMAPE Calculation like - (Sum(Total vMAPE)/Sum(Total Actual)) * 100

Export 1 chart data to xls - (Sum(Total vMAPE) = 0.75

Sum(Total Actual)) - 4.70

= (0.75/4.70)*100 = 16.03

Same value i want in second chart - by selection of MEELES group - i.e - 16.03, But my current expression is giving me - 12.64.

topic vMAPE Calculation Help - Expression in QlikView