Issue with column totals
I’ve come across what seems to be a bug with column totals and rounding.
I have a column where I’ve restricted the decimal places to 2 and put a total on the column.
It seems that the total is calculated based off the non-rounded figures and then rounded, rather than being the sum of the rounded figures. This results in the total being different to the sum of the figures presented in the report as shown in the screen shot below.
The Check GST column is rounded to 3 decimal places and the Total GST column is rounded to 2. Both columns are the same values. Adding the figures from Total GST, I would expect the total to be 2829.89, however, it’s instead summing the non-rounded figures, then rounding the total, that is, the rounded total of 2829.895, as seen in the Check GST column.
I would expect the column total to be the sum of the amounts presented.
Version info is as follows:
Windows Server 2012 R2 6.3 (amd64)
Phone +61 418 680 340
Sales 1300 308 615
Support 1300 780 268