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!