Calculated Attribute column value is blank

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Calculated Attribute value, consisting of addition of two numeric attributes respectively, are coming out blank if one of the numeric attribute’s value is blank. This is observed when the Add calculation option is being used in the calculation logic.

Steps to Reproduce:

1. From Clarity Studio, on any object create two numeric fields. For example: Filter the Project object and create the following numeric fields: Attrib 1 and Attrib 2, respectively. Enable the API Attribute ID for each of these attributes. For reference:
   • 
2. Create a numeric Calculated attribute on the same object and enable API Attribute ID. For example, on the project object, create a numeric Calculated attribute, “Total”, in the calculated logic use the function “ADD” and then add in the fields as created on the step 1
   • 
3. On the MUX, navigate to the Projects link , choose the Grid view, add in the three fields created in the above steps:
   • 
4. Enter the value in the field: Attrib 1 and keep the field: Attrib 2 as blank. For example: enter the number 10 on Attrib 1 field 
   • 

 

Expected Results: 

The Total column should calculate and accordingly display the value as 10

Actual Results:

The Total column value shows up as blank

Cause

This issue has been reported and is being tracked via DE69604

Resolution

This is by design

The function "Sum" could be used in the Calculated Attribute as a workaround