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

    How to sum up absolute deviations?

    Markus Nosko

      Hi

       

      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

       

      Tableau.PNG.png

      Tableau2.PNG.png