Skip to end of metadata
Go to start of metadata
On this page


Example: Setting the priority depending on the multiplication of custom fields

In this example, the priority of an issue should be set depending on the result of multiplying two custom fields.

For this, three custom fields are needed:

  • "Impact" (Default number custom field)
  • "Probability" (Default number custom field)
  • "Rating" (Calculated Number Field) for storing (Impact * Probability)


Depending on the outcome of the multiplication, the priority should be set as the following:

RatingPriority
13-16Highest
9-12High
4-8Medium
1-3Low


The configuration of the Calculated Number Field "Rating" will look like this:


Text to be parsed is: {10417} * {10418}


Note that:

  • {10417} is the field code for "Impact" (this field code might differ on your instance)
  • {10418} is the field code for "Probability" (this field code might differ on your instance)


For this we need the post function Set a field as a function of other fields. The configuration looks like the following:


Text to be parsed is: 

[{10419} >= 1 AND {10419} <= 3]Low
[{10419} >= 4 AND {10419} <= 8]Medium
[{10419} >= 9 AND {10419} <= 12]High
[{10419} >= 13 AND {10419} <= 16]Highest


Note that:

  • {10419} is field code for calculated number field "Rating" (this field code might differ on your instance)


Once configured, the transition will look like this:




Other examples of that function