Jira Product Discovery calculated fields based on selection

[Mazen ElAasser]

I am using a Jira Product Discovery, I have several fields, for example, MAUs field (number), Financial impact field (number) and Risk field(Text), how can I make the options that the people choose translate into a total score in a different field, for example if people put a number that is less than 100 in financial impact field it will give a score of 1, and then if they choose low risk from the Risk field options they get another score of 1 and then if they choose a number larger than 250 in MAUs filed they get a score of 5 and all of this gets summed up in a total score field?

I am aware of some plugins but my admin can't authorise the use of them so I am looking for some sort of workarounds.

[Bill Sheboy · Accepted solution]

Hi @Mazen ElAasser 

Based upon the complexity of your calculation, you may be able to use the built-in custom formulas feature of Jira Product Discovery: https://support.atlassian.com/jira-product-discovery/docs/expression-based-formulas/

If that will not handle your use case, you could perform more complex calculations using the built-in automation for Jira rules: https://support.atlassian.com/cloud-automation/docs/jira-cloud-automation/

Kind regards,
Bill

[Ingo Wenke]

Hi @Mazen ElAasser ,

as Bill mentioned, automation is a good tool to implement your rules. We use automation to calculate the WSJF and it works fine.

Have fun

Ingo

[Richard Kirk]

On the principle of keeping it simple to start with, I'd go with @Bill Sheboy 's suggestion of using a custom formula:

with a type of weighted score and adding your 3 fields as positive inputs: