# Issue with column totals

Aaron Leech shared this idea ago
Idea Logged

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

0

Hi Aaron,

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

0

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]

0

Thanks Aaron.

I will test that again and will get back to you.

Regards,

Mahe

0

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

0

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]

0

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