Form Tools

Full Version: Formulas in Formtools
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
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!