2 Replies Latest reply on Jan 28, 2013 12:53 PM by Joshua Milligan

    Table Calculation Question - Forecast Accuracy Calc

    Keith Rietz

      I am trying to calculate Forecast Accuracy based on Absolute Value differences between Forecast and Sales actuals.  I have attached an excel spreadsheet with the data I'm using (names changed to protect the innocent!) and the desired calculation result.  I cannot get Tableau to give me an Aggregated SUM of Absolute values--it seems to be doing the Absolute calculations at the already Aggregated level....see the attachment for details. 

       

      Thanks for the help!!!