Custom calculated "Overall Status" attribute on Status Report object not working

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

You create a custom "Overall Status" field on the Status Report object which is intended to return the highest Risk level of two factors "Schedule Status" and "Cost and Effort Status" and display the color accordingly.

The formula used for the custom attribute is :

"Max(cop_schedule_status,cop_cost_eft_status)".

Why is the color mapping not working per the formula created?

Environment

Any Clarity release

Cause

On your new Status attribute make sure you change the mappings:

The OOTB mappings are:

• 10-40
• 40-90
• 90-100

The lookups associated with these attributes use these values:

• On Track = 10
• Needs Help = 20
• At Risk = 30

So now because we are just using the value from the max attribute the mappings need to be updated to something like this.

• 0-10
• 11-20
• 21-30

Then the colors work right.

Resolution

Change the Display Mappings to only to 30.