Hi team,
I have requirement we have a risk exposure filed, probability(single choice)
Impact(Single choice field) with below values.
Probaility --very low =1 * high=4 (impact )
value =4
value of 4 have to display in risk exposure field
please help to resolve the below issue.
Risk Exposure Field gets the number based on Probability and Impact selection and the value would be as per the table.
Probability / Impact | Very Low = 1 | Low = 2 | Medium = 3 | High = 4 | Very High = 5 |
Very Low = 1 | 1 | 2 | 3 | 4 | 5 |
Low = 2 | 2 | 4 | 6 | 8 | 10 |
Medium = 3 | 3 | 6 | 9 | 12 | 15 |
High = 4 | 4 | 8 | 12 | 16 | 20 |
Very High = 5 | 5 | 10 | 15 | 20 | 25 |
Example: If I Select Probability as High (Which has Value 4) and Impact Very High (Which has Value 5). The product of it would be 20 and it should reflect in the Risk Exposure.
you could consider using Automation (assumes you are on cloud). Please refer to this documentation- Smart values: math-expressions
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.