8 Replies Latest reply on Oct 25, 2013 4:06 PM by Tracy Rodgers

    How to sum up absolute deviations?

    Markus Nosko



      I have an issue in Tableau when it comes to summing up absolute differences. In the example below I have calculated the "Absolute forecast error" by using the formula ABS(SUM([Adjusted forecast DCH (kg)]-[Actual demand (kg)])). This gives the right values for the two items in the table. However, my challenge comes when I remove the items from the rows to get a total absolute difference. The number I would like to see is 389 (sum of the absolute differences) in Absolute forecast error and not 355 as I get (see the second picture)


      Can someone please help me out on how to reach this result? All comments/ideas are deeply appreciated :-)


      Best regards

      Markus Nosko