Form Tools
Formulas in Formtools - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: Feature Suggestions (https://forums.formtools.org/forumdisplay.php?fid=7)
+--- Thread: Formulas in Formtools (/showthread.php?tid=22358)



Formulas in Formtools - rddejesus - Mar 15th, 2017

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!