3 Replies Latest reply on Apr 8, 2013 6:02 AM by R. van de Vossenberg

    Grand total in Tableau is not correct. Why not?

    R. van de Vossenberg

      In the dataset I have a purchase price per article and the units sold per article. When I multiply the units sold with the purchase price in a calculated field then I get the total purchase value (you can find the column in the excel sheet in the appendix).

       

      The total purchase value is correctly calculated per article (every line in Excel).

      But when I look to the grand total of the column 'total purchase value', it isn't correctly calculated. When I export the data to Excel there's a difference in grand total of 8000. Excel makes a sum of 14.113 where tableau makes a sum of 22.027. What's the problem with the data? Why can't Tableau make the correct calculation?