FORUMS


Current time: Mar 25th, 2017, 7:16 PM Hello There, Guest! (LoginRegister)


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Formulas in Formtools
Mar 15th, 2017, 4:50 PM
Post: #1
Lightbulb Formulas in Formtools
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!
Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)