
1. Re: Tableau SUMs do not match Excel SUMs
Chuck Stevens Jul 27, 2016 3:58 PM (in response to Li Kim Lee)The math is done based on the data type. I have mine read in as decimal data and the sum is correct down to the decimal. If you want your data rounded as is suggested, then simply use the rounded function like  ROUND(SUM([Abc])) . Abc is your measure.

2. Re: Tableau SUMs do not match Excel SUMs
Tom W Jul 27, 2016 5:12 PM (in response to Li Kim Lee)1 of 1 people found this helpfulI created an example with the two values you provided;
It's summing fine for me;
It sounds like the data type on your field within Tableau is setup incorrectly. Make sure your measure is setup as Number (Decimal) and not whole;
If I set my field to whole, I can also replicate 63.

3. Re: Tableau SUMs do not match Excel SUMs
Li Kim Lee Jul 28, 2016 12:58 AM (in response to Tom W)Thanks, Chuck and Tom. All my values were in decimal format, I did check beforehand. However I found out the underlying issue was that my data source had transformed all decimals to whole figures before even reaching Tableau. So the problem lay in my data source  thanks again for responding!