AnsweredAssumed Answered

I would like to create an "Overall Risk Status" field based on 5 Risks (Schedule, Cost, etc.) but without a straight sum calculation.

Question asked by MarkCasey77140488 on Oct 28, 2015
Latest reply on Oct 28, 2015 by urmas

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?

Outcomes