Calculated attribute total row values in UI grid and Excel export do not match

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When viewing a report with a calculated attribute (e.g., multiplying two metric fields) in the Report Designer grid widget, the total row displayed in the UI grid does not match the total row calculated in the Excel export.

In the UI, the total row for a calculated metric attribute is calculated by multiplying the aggregated column totals of the underlying metric fields. Conversely, when exported to Excel, the total row is calculated by summing the multiplied metric values across each individual project row.

Steps to Reproduce:

1. Create a data provider with standard investment and project objects.
2. Add a calculated attribute that multiplies two numeric attributes (e.g., Multiply(Actulas, ETC)).
3. Save the data provider and create a new report (Fixed)  using Report Designer.
4. Add a grid widget to the report, adding the individual numeric columns and the calculated attribute column.
5. Enable the total row on the grid widget in the UI.
6. Observe the total row value displayed for the calculated attribute.
7. Export/download the grid widget to Excel and compare the total row value.

Expected Results:

The total row values and aggregation logic should be consistent between the UI grid and the Excel export.

Actual Results:

The UI grid total row multiplies the total aggregated values of the underlying metric attributes together, whereas the Excel export total row calculates the sum of the individual multiplied values across each project row.

Workaround:

In the Report Designer under Value Aggregation settings for the Total column, uncheck the "Calculate at the group level" toggle and set the aggregation method to "Sum".

Environment

Clarity 16.4.2

Cause

Due to DE210001

Resolution

 DE210001 is fixed in Clarity 16.5.0.