3 Replies Latest reply on Jul 28, 2016 12:58 AM by Li Kim Lee

    Tableau SUMs do not match Excel SUMs

    Li Kim Lee

      Hello. I have an issue where a series of summed-up figures are off by 1 or 2 digits. We can accept a small variance but when viewed collectively the error is then significant. In Excel, A+B=C. In Tableau A+B~C because decimals are not being considered. So Tableau is rounding figures before the summing or calculation happens.

       

      For example:

       

      52.225 (displayed as 52 in Excel and Tableau)

      +

      11.464 (displayed as 11 in Excel and Tableau)

      =

      64 in Excel (correct) but 63 in Tableau (wrong)

       

      How can one rectify the above simply? My data set has lots of metrics and calculations, etc. Thanks!