Issue with column totals

Aaron Leech shared this idea 3 years 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.

daa66d5229d78e82578fd5987db70f2f

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

Comments (6)

photo
0

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:


d810df4264cfc27a1dade797189eefd2


37934a90196ffeb00fd530c29cfd55fd


84b9a51890aa3832fefa4bbd35324763


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

photo
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:

cdc2f6ea86cfc0b4c7b12f2323eacb20

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]

photo
0

Thanks Aaron.


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


Regards,


Mahe

photo
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:


fac7ce07d7a92f042cc6793c284d7ab9


bb172df6f1973dd9f10f9783d83e127f


Please make changes and see how you go with it.


Let me know if you have any queries.


Regards,


Mahe

photo
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,

e47a20079c11e5f5163475beb028b34e

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]

photo
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