FORUMS


Hello There, Guest! Register


Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Formulas in Formtools
#1
Lightbulb 
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!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)