Calculate value from other drop-down-fields

[Markus Lepper]

Hello,

for a risk process I want to calculate a "Risk Value" from other fields.

- I have two drop-down-fields: "Severity" and "Probability", each with selectable values 1, 5 and 10.

- Another field "Risk Value" shall contain the multiplication "Severity*Probability"

- On each change of the Severity or Probability field (in Edit mode) the "Risk Value" field shall be updated

- "Risk Value" field itsellf shall be readonly/not directly changable.

I tried with "Jira Workflow Toolbox" which has great mathematical functions but it needs two number fields as input. Drawback is taht users could enter any value there...and I need to provide some fixed values.

Any idea how to implement this as easy as possible.

Thanks & BR,

Markus

[Betsy Walker · Accepted solution]

You can also use the Behaviors plugin to do this, invoking your calculation function whenever a user modifies any field that affects the calculation. I used it to create a running total of several fields that needed to sum to 100 and store it in a field's Description, but you could also use it to set other fields to a calculated value.

[Jobin Kuruvilla [Adaptavist]]

You will have to write your own plugin as it is not a very generic requirement from the look of it. I haven't seen any plugins already existing for this.

Write a listener which captures the changes to the select fields and calculates the 'Risk Value' field!

[dmitry dementiev]

if you are a developer, it would be rather easy to add some javascript on your page. Yes, i suppose, you should write simple jira-plugin.

Cheers, Dmitry.