I have been working on a forecast accuracy report in Qlik Sense. I have a pivot table displaying daily sales qty's & forecast qty's, volume error and percentage error measures. The issue that I am having is that when applying the total function to the pivot table, the error volume measure is not picking up the values from the FAB calc. It is netting the negatives off of the positive values and giving a much lower result that expected.
The results I am getting are all positive and can be seen in the screenshot below. I think you can clearly see that both totals on both rows are giving the net of Positives + Negatives = 96 where the intended result would be 742, basically the total variance from forecast.
The Dimension to be totaled would be [WeekDay].
If you could help, steer me in the right direction I would be extremely grateful.