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?
Release : All Supported
On your new Status attribute make sure you change the mappings.
The OOTB are
The lookups associated with these attributes use these values:
So now because we are just using the value from the max attribute the mappings need to change to something like this.
then the colors work right.
Change the Display Mappings to only to 30.