Total number does not match?

Owned by Elena Velytchenko (Unlicensed)
Last updated: Apr 04, 2018 by Andriy Zhdanov
1 min read

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: