Total number does not match?

Because of Maximum Fraction Digits configured in add-on configuration, total number of hours shown on report page may not match total calculated by applying SUM formula to exported worklog in Excel.

When Maximum Fraction Digits configured, hours are displayed as individually rounded values, but total in the report is calculated on exact values, and then rounded. In Excel, every entry is rounded, so if you apply SUM you get incorrect result. There is Total row for exported worklog, to avoid this confusion.


See also related issues 1173 and 937



Didn't help? Find different article: