3 Replies Latest reply on Oct 8, 2018 10:37 PM by Mikhail Christiansen

    Grand Totals <> Sum of Rows

    Mikhail Christiansen

      Hello everyone,


      I am using Tableau Desktop 10.5. I have a calculation that is causing me issues, recreated below with Superstore data. The problem is being caused by the following calculation:



      When I add on grand totals, the totals do not equal the sum of the rows, rather it is taking my sum of total sales * .1, the ELSE part of the calculation.





      Please review and help me know if there is a way around this.