Custom formula point error when using newly created rating field

신준오(Johnny)

 

If I select the newly created rating field, the score is not calculated in the custom formula based on the selected rating.

 

1. These are the current custom formula settings.

 

 

2. There are two severity fields, one of which is a new field I created.

 

 

3. If I set the original severity to "Very Low," 20 points will be assigned. I believe this is normal.

 

 

4. However, if I set the newly created severity to "Very Low," 100 points are assigned.

 

 

Tanguy Crusson

Hi, that's actually expected. See details here: https://support.atlassian.com/jira-product-discovery/docs/expression-based-formulas/

here's how it works:

• for each field, the formula plots each idea on a 0-100 scale (the idea with the lowest field value gets 0, the one with the highest value gets 100, the others are plotted in between)
  • So, in your case, the idea with "severity new = 1" gets 100, all the others with no value get 0.
  • And the idea with "severity = 5" gets 100 as well
• Then the weighted score gets calculated. In your case, both "severity" and "severity new" get equal weighting. So they land with the same score. 

This works well when you have fields of different scales, for example one field with a 1-5 scale and another one with a 1-100 scale. But I agree that in your case it can look weird.

---

As an alternative, if every field you have is a 1-5 scale, you could use a formula of type "write your own": 

Score = Business * 25 + value * 25 + severity * 25 + {severity new} * 25

(or simply Business * value * severity * {severity new} since all options have the same weight)

And then you can create a formula of type "weighted score", which takes only one input (Score).

I think this would work better for you.