Hello ! I am very new to QV.
Please see attached..
the dispersion work great on the individual months, but the aggregate accuracy/dispersion isn't working correctly.
The dispersion needs to be the 'sum of the rows of the ABS(error) / total Lag3 forecast.
What are your expressions for ABS and Lag3? Wrap them around with Sum(Aggr(, Dimensions)) and it should work fine
Sum(Aggr(ABSExpression, YourDimensions))/Sum(Aggr(Lag3Expression, YourDimensions))
Actual Sales = Sum ([Actual Sales])
Lag3 Forecast = Sum ([Lag3 Forecast])
ABS Error = fabs(Sum ([Actual Sales])-Sum ([Lag3 Forecast]))
Accuracy = Sum ([Actual Sales])/Sum ([Lag3 Forecast])
Dispersion = (fabs(Sum ([Actual Sales])-Sum ([Lag3 Forecast]))) /( Sum ([Lag3 Forecast]))
I assume that if I remove the DmdUnit and Actual Month's fields from the table - it will no longer work ?
Let's say I only want a simple table that just shows that accuracy and dispersion for the selected dmdunit and months - but not actually in the table ?
If you remove the DmdUnit and Actual Month fields as dimensions the calculations should still work, you just won't be able to see the accuracy and dispersion per Dmdunit/Actual Month combination anymore, just the total. But if you only want to see these 2 values then you might be better off using text box objects as Sunny suggested, that might look a bit better.