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.
1 of 1 people found this helpful
I 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.
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!