Total Row Always 0 for Custom Time-Varying Attributes (PostgreSQL)

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Total row does not aggregate values from custom time-varying attributes when using Clarity on a PostgreSQL DB.

Steps to Reproduce:

1. Use a Clarity instance running on a PostgreSQL DB.
2. Create a new Time-Varying attribute in the Cost Plan Detail object:
   
   • Data Type: Time-varying
   • Time-varying Type: Fiscal
   • Time-varying Data Units: Number
3. Navigate to a project with a cost plan and open it.
4. Add the Per-Period Metric attribute created in Step 1 as a column in the Grid view.
5. Configure the View Options to Show Total Row.
6. Add any values into the attribute.

Expected Results: The Total row displays a total based on the Value Aggregation selected (Sum, Average, ...).

Actual Results: The Total row always displays 0.

Environment

Clarity 16.3.3

Cause

DE177422

Resolution

This issue is under review.