I would like to create an "Overall Risk Status" field based on 6 Risk Analysis Category fields (Schedule, Cost, etc.) with High, Medium, or Low values. However, we need to do it without a straight sum calculation. Instead, we would like the Overall Risk Status field to reflect the highest risk found, e.g.,
High if any of the Risk Analysis Categories are high risk, otherwise
Medium if any of the Risk Analysis Categories are medium risk, otherwise
Low overall risk.
What is the best way to do this?