Pivot By User report: Total number does not match

Issue #1173 resolved
Bogdan Kharchykov created an issue

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

Comments (11)

  1. 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 support@jiratimesheet.com.

    Thank you.

  2. 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.

  3. 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).

  4. Bogdan Kharchykov reporter

    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.

  5. Bogdan Kharchykov reporter

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

  6. Log in to comment