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.
Hi, that's actually expected. See details here: https://support.atlassian.com/jira-product-discovery/docs/expression-based-formulas/
here's how it works:
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.