Can I create a Customer Number field with entries based on a calculation using other Fields?

[Russ Willis]

Hi there, I am a JIRA Administator / Manager with no training in JIRA Administration.  I have joined a FinTech that uses JIRA Cloud.  It has almost 1000 tickets in it's current Backlog.
   Thus, for a first step to managing this Backlog, I want to create a Custom Field ("Value Effort") that uses a ticket's Total Delivery Value divided by it's Effort Required to Deliver (an oversimplification, but you get the point) and automatically assigns a "Value Effort" number to each ticket.

   We have the (estimate) fields related to Total Delivery Value, and Effort Required to Deliver on our User Stories.  Thus, I need to configure the Custom Field of "Value Effort" and base it's automatically derived value on an equation using the existing fields.

   Now, my question:  Can this even be done with JIRA Cloud (not Premium)?  Do I need Add-Ins, if so?

I have looked in the Custom Field configuration and see how to set up the Field and assign it to Screens, but I see nowhere to imbed an equation to be used in automatically deriving the value of this "Value Effort" field.

   Thank you for any insight you can provide.

[Reshma Begum {Appfire}]

Hello @Russ Willis ,

Our JMCF app provides scripted fields with which you can perform calculations like division on custom fields.

You can install a trial version of our app from the marketplace and create a Scripted Number field with the script below. 

const effort = await api.issue.getField(issue, "customfield_10141")

console.log(effort)

const deliver = await api.issue.getField(issue, "customfield_10140")

console.log(deliver)

if (effort !== null) {

const res = deliver/effort

return res.toFixed(2)

}

Make sure to modify the custom field IDs of Total Delivery Value, and Effort Required to Deliver fields in the script above. 

Please see our documentation on scripted fields for more details.

Please feel free to open a support request from here if you have any questions.

BTW, I am from Appfire, a vendor of JMCF.

Thanks,

Reshma

[Russ Willis]

Cheers Reshma.  I'll check this out.

[Mikael Sandberg]

Hi @Russ Willis,

Welcome to Atlassian Community!

It can be done with automation, but on the standard plan you are limited to 1700 runs per month, see this KB. So you would either have to go to Premium or use one of the scripting apps available in the Marketplace. I have used both Scriptrunner and Power Scripts in the past and both can do this.

[Russ Willis]

Thank you Mikael.  Does "1700 Runs" mean executing the Script once and it applies the calculation for all Backlog items, or does each Backlog Item count as a single Run?  

[Jehan Bhathena]

Hi @Russ Willis 

You can try this https://help-seibertmedia.atlassian.net/wiki/spaces/ACF/pages/77037570/Advanced+Formula

It's a free plugin so won't cost you for learning it out. 🙃

[Russ Willis]

Thank you Jehan.  I'll look into this.