ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 212557

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

You creat 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?

Cause

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

The OOTB 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 change to something like this.

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

then the colors work right.

Environment

Release : All Supported

Resolution

Change the Display Mappings to only to 30.