Risk Assessment Metric

[nyrguy451]

I have an odd request that I am having trouble figuring out.  We have a risk assessment form that is being used universally across all change types (Standard, Normal, Emergency, and Expedited). This form consists of 6 questions all with risk choices of  HIGH - MODERATE - LOW.

What is being asked, is regardless of the value assigned to the selection that the risk is based on the highest selection of the questions. See below for example

1. Question = Low
2. Question = Low
3. Question = Low
4. Question = Low
5. Question = Low
6. Question = Moderate

RISK = MODERATE

1. Question = Low
2. Question = Moderate
3. Question = Moderate
4. Question = Low
5. Question = Moderate
6. Question = High

RISK = HIGH

I am not certain how to achieve this result considering all of the choices have set numeric values and are weighted against another metric.

Any suggestions would be much appreciated.

[SebastianKunzke · Accepted solution]

I don't know, if you could script it. But my idea would be to set the threshold to a certain level.

In your case, if would achieve it in this way:

Value for low = 0.

Value for moderate = 1, Moderate threshold = 1

Value for High = 7, High threshold = 7

Why? Because 6 questions answered with moderat 1 --> result = 6 

So short formula:

"Value of lower level" x "Number of questions" + 1 --> "Value of the next value & threshold"

In case you have other metrics you need to make sure, that the values can be compared. Therefor you can modify the weight of the different metrics. 

Hope this helps.

[nyrguy451]

Thank you, Sebastian,

Simple math eluded me on this one. 

I will mark as correct