Straight Table Calculations

[Anonymous]

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.

Help,,,,

[Anonymous]

Table works great with new formula.

Now, I copy the table and remove the dmdunit and actual month:

Sales, Forecast are correct, but the ABS Error is only showing the difference.. it should be the sum of the months selected (but not in the table). I assume the formula needs to change :

@sunny talwar  - Can you assist again on this formula?

[sunny_talwar]

So, the issue is ABS Error expression now and not Dispersion, right? Try this for ABS Error

Sum(Aggr(fabs(Sum ([Actual Sales])-Sum ([Lag3 Forecast])), [*DmdUnit], [Actual Month]))

[Anonymous]

Beautiful !!!!

Thank you very much... You have saved the day !

[jensmunnichs]

Alan,

Have a look at this blog post. I think it'll explain what's happening in your total row.

Totals in Charts

TL;DR; unless specified otherwise, the total line in a table will try to calculate the expression over the full set of data in your table. So in this case it would sum all actual sales and sum all forecasted sales and calculate the difference. If you want it to show sum instead, use Sunny's expression instead or switch the 'total mode' in the expression tab to 'sum of rows' for this expression.

[sunny_talwar]

Glad to help. Please close the thread by marking correct and helpful responses.

Best,

Sunny