search cancel

Labor ETC Group By amounts not correct for FTE/Days

book

Article ID: 240651

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

When viewing the Labor ETC value in Group By mode, the computed amount for FTE/Days is slightly higher than manually computing the total amount. 

Steps to Reproduce: 

  1. From your Avatar, Settings, General, pick 'FTE' or 'Days' for the Unit of Measurement 
  2. On the Project, Idea or CIT MUX common grid, add the Per-Period Metrics for ETC (Labor ETC) 
  3. Ensure the Investment-level ETC values are updated through the 'Update Investment Allocation and Usage' job 
  4. Select a common-value field for 'Group By'  
  5. Examine the grouping row totals for the ETC columns 

Expected Results: The Group By total amount should be correctly computed for FTE/Days. 

Actual Results: The Group By is resulting in a higher FTE computation. In a non-Group By mode, the API returns the correct total amount. 

Cause

DE64722  - The problem is caused by the pre-existing aggregation method used for the laborETC field.  It is dropping the time stamp portion of the last segment on the aggregated curve so that the divisor (available work time) is slightly smaller than it should be resulting in a higher FTE computation than expected. 

Environment

Release 16.0.2 

Resolution

Targeted Fix in Release 16.0.3