K
Keoni
My customer has a requirement to take data entered from two fields on the
risks page and automatically have it generate another data value. I know how
to do this using a calculated value column if the data entered is a numerical
value and the outcome is a numerical value. However, the data entered is
alphanumeric and the outcome needs to be alphanumeric. For example:
The first column they want is Likelihood. The values for Likelihood are
Remote (20%), Unlikely (40%), Likely (60%), Highly Likely (80%), and Near
Certainty (99%).
The second column is Consequence. The values for Consequence are Minimal,
Slight, Acceptable, Significant, and Unacceptable.
The third column, Priority, is a calculated value field. The values they
want to come up from the calculation from Likelihood * Consequence are High,
Moderate, and Low.
After some discussion I told them that we could put in the description that
20 meant Remote, 40 meant Unlikely, and so and so forth. This would allow me
to also assign a numeric value to the values of Consequence. It was as
follows: 1 is associated with Minimal, 2 was associated with Slight, and up
to 5 being associated with Unacceptable.
Doing this allowed me to get a numeric value. However, the customer was not
satisfied with having a numeric value for Priority. They still wanted Hot,
Moderate, or Low. My question is how do I create a formula to associate the
numeric product value from Likelihood and Consequence to Hot, Moderate, and
Low?
Hope this all makes sense :-(
risks page and automatically have it generate another data value. I know how
to do this using a calculated value column if the data entered is a numerical
value and the outcome is a numerical value. However, the data entered is
alphanumeric and the outcome needs to be alphanumeric. For example:
The first column they want is Likelihood. The values for Likelihood are
Remote (20%), Unlikely (40%), Likely (60%), Highly Likely (80%), and Near
Certainty (99%).
The second column is Consequence. The values for Consequence are Minimal,
Slight, Acceptable, Significant, and Unacceptable.
The third column, Priority, is a calculated value field. The values they
want to come up from the calculation from Likelihood * Consequence are High,
Moderate, and Low.
After some discussion I told them that we could put in the description that
20 meant Remote, 40 meant Unlikely, and so and so forth. This would allow me
to also assign a numeric value to the values of Consequence. It was as
follows: 1 is associated with Minimal, 2 was associated with Slight, and up
to 5 being associated with Unacceptable.
Doing this allowed me to get a numeric value. However, the customer was not
satisfied with having a numeric value for Priority. They still wanted Hot,
Moderate, or Low. My question is how do I create a formula to associate the
numeric product value from Likelihood and Consequence to Hot, Moderate, and
Low?
Hope this all makes sense :-(