Sum the custom number fields and calculate the percentage based on the sum

[Shamanth]

Hello there,

I am trying to add all the numbers of a custom field for the entire issue list. I am not sure how I can store that sum value and use it later for calculating the percentage. I am on a Jira Datacenter and the automation does not yet have the custom variable feature.

Below is a sample table which I created on Excel to help you understand in detail.

Each issue will be having 3 such custom fields (Fixed, Pending & Total). I want to find the percentage of "Fixed" by adding the numbers from all the issues and divide that number by the sum of Total. The same goes for "Pending" percentage as well.

How do I do this? I would like to use Jira automation for this task.

[Bill Sheboy]

Hi @Shamanth 

You are correct that the Server/Data Center version of automation does not have the Create Variable or Lookup Issues features, as does Jira Cloud automation.

However, Server/Data Center does have the bulk processing feature for branches and scheduled triggers, and with that you could do what you ask by calculating on the {{issues}} smart value.

To learn more, please look here: https://confluence.atlassian.com/automation/run-a-rule-against-issues-in-bulk-993924653.html

Kind regards,
Bill