I'd like to perform some calculation (get the product of two custom fields)

Question

I have two select type custom fields and its values are combined numbers and letters.

Example values:

Risk Probability (select type custom field)

1 VERY LOW
2 LOW
3 MEDIUM
4 HIGH
5 VERY HIGH
6 EXTREME

Risk Probability (select type custom field)

1 VERY LOW
2 LOW
3 MEDIUM
4 HIGH
5 VERY HIGH
6 CRITICAL

Here's how calculation should be done.

Impact(Exposure) = left([RISK IMPACT],1) * left([RISK PROBABILITY),1)

or in simpler writing,

Impact = Risk Impact * Risk Probability

Thanks in advance!

Ravi Sagar _Sparxsys_ · Answer

@Paolo Cruz Risk Register is a great add-on for doing Risk Management. I also suggest looking at it.

Craig Schwarze _ProjectBalm_ · Answer

Hi Paolo,

Our solution will do this for you off-the-shelf. If you get a moment, you might want to check it out - https://marketplace.atlassian.com/apps/1213146/risk-register?hosting=cloud&tab=overview

kind regards,
Craig Schwarze
ProjectBalm