Grouped by row data incorrect with Grand Totals and Effort displays in days

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Common grid view Per period Metrics show wrong figures at the grouped by row when the View Options are set to Grand Totals and Effort displays in days

 

Steps to Reproduce:

1. Classic Administration > Project Management > Base Calendars
2. Create a 37.5 hour calendar and set it as Standard.
3. Set the calendar shifts to 7.5 hours daily
4. Create a resource and add the above calendar to the same
5. Create a project that spans from 03/01/25 to 03/31/25
6. On the Staff tab add the allocation field to the Per Period Metrics
7. Group by Resource
8. User settings > Set Effort to Hours
9. View Options:
   • • Periods > Project Start - Project Finish
     • Totals > Sum of Periods
10. Totals displays 157.50 (21 days x 7.5 hours) hours for the resource row as well as the group by row
11. View Options:
    • • Periods > Project Start - Project Finish
      • Totals > Grand Totals
12. Totals displays 157.50 (21 days x 7.5 hours) hours for the resource row as well as the group by row
13. Change User settings > Set Effort to Days
14. View Options:
    • • Periods > Project Start - Project Finish
      • Totals > Sum of Periods
15. Totals displays 21 days for the resource row as well as the group by row
16. View Options:
    • • Periods > Project Start - Project Finish
      • Totals > Grand Totals

Expected Results: Totals displays 21 days for the resource row as well as the group by row

Actual Results: Totals displays 21 days for the resource row but 22.50 for group by row.

The group by row is calculated by 7 hours (157.5 hours / 7 hours) a day instead of 7.5

Environment

Clarity 16.2.1, 16.2.2, 16.2.3, 16.3.0, 16.3.1

Cause

This is caused by DE167777

Resolution

This is fixed in Clarity 16.3.2

Additional Information

This is also reproducible on the Staffing workspace, Staff module.