Complex Calculated Fields

[Greg Bammel]

What is the best way to create a custom complex calculated field?  For example, I have fields priority and severity.  I wanted both priority and severity to map to a number.  The calculated field should be the multiplication of those two fields?  Is this possible?  If yes, what is the best way to tackle it? 

[Mikael Sandberg · Accepted solution]

Hi @Greg Bammel,

Welcome to Atlassian Community!

You have a couple of options to do this. You could use automation to do the calculation via smart values and math expressions. Another option would be to use something like Scriptrunner, it has calculated fields that you could use or you could write a script that does the calculation. Back in the days when I was on Jira Data Center I created a Scriptrunner script that calculated three different fields to get a risk value. 

[Vincent Mutambuki { Mumo Systems }]

You can create use Abacus to create a formula with two custom fields and a results fields as shown below. 

Then create an execution plan and use the map field values action to map Priority values to numbers. Make sure to store the value to the MappedPriority number field you created in the formula above.

Add another map field value action to map severity values to numbers. Lastly, add you formula which will use the mapped values to do calculations based on the issue event trigger you select. 

Disclosure - I represent Abacus vendor.  This is not intended to be a commercial but to solve a this problem. Use it at your will.

[Bill Sheboy]

Hi @Vincent Mutambuki { Mumo Systems } 

When recommending a marketplace vendor product, please ensure you disclose your affiliation to that vendor in your post wording. For more information about this, please see:

Atlassian Community online guidelines for Marketplace and Solution Partners

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Atlassian-Community-online-guidelines-for-Marketplace-and/ba-p/689723

Kind regards,
Bill

[Riley Venable]

You can use the arithmetic operations mentioned in the context to create a custom complex calculated field. For example, you can set the custom field to be the multiplication of the priority and severity fields by using the expression "{{Priority}} * {{Severity}}".