11 Replies Latest reply on Aug 23, 2016 3:00 PM by Beth Hurst

    How to change the order of operation in a Grand Total of a Calculated Field

    Beth Hurst

      I have a calculated field called 'Score Current'.  I'm having Tableau compute using 'Vendor' and am displaying this score by 'Term Cd'.  The answer is what I expected it to be for the individual 'Term Cd' by Vendor.  However, the Grand Totals are not behaving the way I want them to.  I want Tableau to Sum the Products, but it is Summing first then calculating the resulting product.  I've attached a workbook.  I'm using Vendor A as an example in the Excel screen shot below.  Tableau returns a Grand Total for 'Score Hist' of 34.3 instead of 26.4.