Pivot By User report: Total number does not match

[Bogdan Kharchykov]

Run the report for the month of September: total number of hours shown on report page: 1773.7

Export report to Excel

Apply SUM formula: Total number is 1777.5

[Oleksandr Velytchenko]

HI Bogdan

please clarify what platform do you use, server or cloud?

Best regards

[Bogdan Kharchykov]

Cloud

[Andriy Zhdanov]

Hi Bogdan,

Could you please collect support data to let me reproduce it locally? Enable Track Support Data option in add-on configuration, then reload report and click Download Support Zip button, and send it to [e-mail].

Thank you.

[Bogdan Kharchykov]

sent

[Andriy Zhdanov]

Well, I think it's the matter of rounding.

When you sum up individually rounded values you get different result than rounded sum of not rounded values.

Sorry, it took it so long.

[Bogdan Kharchykov]

at what point do they get rounded?

[Andriy Zhdanov]

Every individual value displayed is rounded to Maximum Fraction Digits configured in add-on configuration, or 2 by default.

Note, timespent in JIRA has 1 minute precision, even though is stored in seconds, but in report it's displayed in hours (rounded).

[Bogdan Kharchykov]

I am afraid you have a bug then. Each individual value in Total column is rounded to "Maximum Fraction Digits " but the Grand Total (bottom right value) does not represent the sum of rounded Totals, but is getting rounded AFTER the grand total is calculated. This problem was highlighted by excel export - if you sum up each individual rounded total, it will not match the grand total.

[Andriy Zhdanov]

Consider you pay $1 per hour, would you pay sum of rounded values?

[Bogdan Kharchykov]

ok I agree - please close the ticket. The lost rounding information on export is confusing though, you may want to do something about it.

[Andriy Zhdanov]

There is Total row, exactly for this.