Calculating Risk - Number of Users affected
Hi there,
For some reason I seem to be at a loss in calculating risk.
I have a formula test field which must hold the following values:
No Impact
Low
Minor
Major
Critical
The c...
Forum Discussion
Try something like this in a formula text field. You shouldn't need the and comparison, it will check each one in order
If(
[Classification] = "Risk", "No Impact",
[Number of users Affected]<=96, "Low",
[Number of users Affected]<=1200, "Minor",
[Number of users Affected]<=7500, "Major",
[Number of users Affected]>7500, "Critical")
------------------------------
Everett Patterson
------------------------------
If(
[Classification] = "Risk", "No Impact",
[Number of users Affected]<=96, "Low",
[Number of users Affected]<=1200, "Minor",
[Number of users Affected]<=7500, "Major",
[Number of users Affected]>7500, "Critical")
------------------------------
Everett Patterson
------------------------------