Calculate risk matrix

gavinburgess

Hi in my survey I have two 'select one' list questions based on Likelihood (Certain to Rare) and Consequence(Negligible to Major). I'd like a message to popup with the resultant Risk Level based from the selection of these two fields. i.e. If Unlikely and Minor is selected, I want a popup to say Moderate Risk.

If not, can this be done with a note?

JohnBickmore

I have done this by using numbers as the choice names (first table) then using formulas in the relevant collumn to display the relevant risk 'notes'

I have only 4 risk class but should work with 5?

   

Liklihood	5	Almost Certain - Expected to occur regularly
Liklihood	4	Likely - Will probably occur
Liklihood	3	Possible - Might occur occasionally
Liklihood	2	Unlikely - Could happen at some time
Liklihood	1	Rare - May happen only in exceptional circumstances
Consequence	1	Negligible
Consequence	2	Minor
Consequence	3	Moderate
Consequence	4	Major
Consequence	5	Severe

 

${Liklihood}*${Consequence}>0.5 and ${Liklihood}*${Consequence}<=4

${Liklihood}*${Consequence}>4 and ${Liklihood}*${Consequence}<=10

${Liklihood}*${Consequence}>10 and ${Liklihood}*${Consequence}<=16

${Liklihood}*${Consequence}>16

${Liklihood}*${Consequence}>4 and ${Liklihood}*${Consequence}<=16