Mar 15th, 2017, 4:50 PM
Hi guys,
I am currently developing a risk assessment that involves computing. The risk assessment formula is as follows:
Probability * Highest among 5 impacts (5 columns) * Existing Control Measure = Risk rating
The it will translate to a case statement that will reflect the following in ():
Risk rating >= 20 (High)
Risk rating >= 12 and < 20 (Medium)
Risk rating >= 5 and < 12 (Low)
Risk rating < 5 (Lowest)
Any tips?
Thank you!
I am currently developing a risk assessment that involves computing. The risk assessment formula is as follows:
Probability * Highest among 5 impacts (5 columns) * Existing Control Measure = Risk rating
The it will translate to a case statement that will reflect the following in ():
Risk rating >= 20 (High)
Risk rating >= 12 and < 20 (Medium)
Risk rating >= 5 and < 12 (Low)
Risk rating < 5 (Lowest)
Any tips?
Thank you!