Issue with column totals
Hi,
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:
Application Version:
7.2
Build:
20170404
Java Version:
1.8.0_121
Operating System:
Windows Server 2012 R2 6.3 (amd64)
Thanks,
Aaron Leech
BI Developer
Phone +61 418 680 340
Sales 1300 308 615
Support 1300 780 268
I like this idea 
Hi Aaron,
Thanks for your email.
I have installed the 7.2, build 20170404.
Below is the screenshot of my example with the same data as you have. I made a CSV file and created a report using that data from the CSV:
I am just wondering what could be the difference between what I did and you did?
I am attaching the CSV file which I have used in this case.
If you don't mind please make a video of the report you have made or the screenshots, so that I can do it similar way.
Please let me know if you have any questions.
Regards,
Mahe
Hi Aaron,
Thanks for your email.
I have installed the 7.2, build 20170404.
Below is the screenshot of my example with the same data as you have. I made a CSV file and created a report using that data from the CSV:
I am just wondering what could be the difference between what I did and you did?
I am attaching the CSV file which I have used in this case.
If you don't mind please make a video of the report you have made or the screenshots, so that I can do it similar way.
Please let me know if you have any questions.
Regards,
Mahe
Hi Mahe,
I believe you are getting a different result as you have put the figures in the database already rounded to two decimal places.
In my example, both columns are reading the same figures from the database, except one is rounded to 3 places and the other to 2 places.
If you alter the Check GST column to be rounded to 2 decimal places in the column settings I believe you’ll get the same results I am getting. EG:
Eg Check GST Rounded to 3 decimal places:
Then the same column rounded to two decimal places:
As you can see here, the total in the second screen shot is the rounded version of the total in the first screenshot, rather than the sum of the rounded amounts.
Thanks,
Aaron Leech
BI Developer
Phone +61 418 680 340
Sales 1300 308 615
Support 1300 780 268
From: Mahe Thatipamula [mailto:support@yellowfin.bi]
Sent: Monday, 1 May 2017 4:48 PM
To: Aaron Leech
Subject: Re: Issue with column totals [#2567]
Hi Mahe,
I believe you are getting a different result as you have put the figures in the database already rounded to two decimal places.
In my example, both columns are reading the same figures from the database, except one is rounded to 3 places and the other to 2 places.
If you alter the Check GST column to be rounded to 2 decimal places in the column settings I believe you’ll get the same results I am getting. EG:
Eg Check GST Rounded to 3 decimal places:
Then the same column rounded to two decimal places:
As you can see here, the total in the second screen shot is the rounded version of the total in the first screenshot, rather than the sum of the rounded amounts.
Thanks,
Aaron Leech
BI Developer
Phone +61 418 680 340
Sales 1300 308 615
Support 1300 780 268
From: Mahe Thatipamula [mailto:support@yellowfin.bi]
Sent: Monday, 1 May 2017 4:48 PM
To: Aaron Leech
Subject: Re: Issue with column totals [#2567]
Thanks Aaron.
I will test that again and will get back to you.
Regards,
Mahe
Thanks Aaron.
I will test that again and will get back to you.
Regards,
Mahe
Hi Aaron,
I have tested it and by changing the Rounding to "Round Half Down" has given me the expected result. Please see the screenshots below:
Please make changes and see how you go with it.
Let me know if you have any queries.
Regards,
Mahe
Hi Aaron,
I have tested it and by changing the Rounding to "Round Half Down" has given me the expected result. Please see the screenshots below:
Please make changes and see how you go with it.
Let me know if you have any queries.
Regards,
Mahe
Hi Mahe,
I still believe this to be a bug. There should be no circumstance where the total does not equal the sum of the amounts shown, regardless of rounding settings.
Having to change the default rounding across all columns in our reports to potentially compensate for this issue is not an ideal scenario.
Could you please raise this as a software bug.
Thanks,
Aaron Leech
BI Developer
Phone +61 418 680 340
Sales 1300 308 615
Support 1300 780 268
From: Mahe Thatipamula [mailto:support@yellowfin.bi]
Sent: Tuesday, 2 May 2017 9:03 AM
To: Aaron Leech
Subject: Re: Issue with column totals [#2567]
Hi Mahe,
I still believe this to be a bug. There should be no circumstance where the total does not equal the sum of the amounts shown, regardless of rounding settings.
Having to change the default rounding across all columns in our reports to potentially compensate for this issue is not an ideal scenario.
Could you please raise this as a software bug.
Thanks,
Aaron Leech
BI Developer
Phone +61 418 680 340
Sales 1300 308 615
Support 1300 780 268
From: Mahe Thatipamula [mailto:support@yellowfin.bi]
Sent: Tuesday, 2 May 2017 9:03 AM
To: Aaron Leech
Subject: Re: Issue with column totals [#2567]
Hi Aaron,
Sorry for delay in replying on this ticket.
I have discussed with team members and we are going to raise this as an enhancement request.
At the moment Yellowfin gets a sum by adding the underlying values - not the superficially formatted number because that is only cosmetic. And we feel this is the industry standard because this is how Excel sums formatted values as well.
But that's good you brought this to our attention and will make that change as we think it's a good idea you have.
I will update you once I hear from dev's.
Please let me know if you have any questions.
Regards,
Mahe
Hi Aaron,
Sorry for delay in replying on this ticket.
I have discussed with team members and we are going to raise this as an enhancement request.
At the moment Yellowfin gets a sum by adding the underlying values - not the superficially formatted number because that is only cosmetic. And we feel this is the industry standard because this is how Excel sums formatted values as well.
But that's good you brought this to our attention and will make that change as we think it's a good idea you have.
I will update you once I hear from dev's.
Please let me know if you have any questions.
Regards,
Mahe
Replies have been locked on this page!