nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Calculate total sum in Jira

Leena Pratheepan

Hello,

I would like to see the total net amount of the child issues in the epic.

I have tried to create the rule, unfortunately it does not work, although the audit log says that it was successful, can someone help me?

Many thanks in advance.

Note: both custom fields are number fields

Best Regars, Leena

Accepted answers

Bill Sheboy

Hi @Leena Pratheepan

When you branch to the parent issue (i.e., Epic) it cannot see its child issues' data. Instead try using the Lookup Issues action with JQL to gather the child issues, and then use the sum function: https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Lookup-issues

For example...

trigger: your field value changed
condition: on the issue type
branch: to the parent
- action: lookup issues, with JQL to find the children of the epic
  - project = yourProjectName AND parent = {{issue.key}}
- action: edit issue (the epic) with the sum of the field
  - {{lookupIssues.customfield_10326.sum|0}}

Kind regards,
Bill

All comments

Rebekka Heilmann (viadee)

Hi @Leena Pratheepan

can you elaborate on "does not work"? Does it not do anything?

Can you share the Audit Log's Details i.e. "show more"?

Bill Sheboy

Hi @Leena Pratheepan

For example...

trigger: your field value changed
condition: on the issue type
branch: to the parent
- action: lookup issues, with JQL to find the children of the epic
  - project = yourProjectName AND parent = {{issue.key}}
- action: edit issue (the epic) with the sum of the field
  - {{lookupIssues.customfield_10326.sum|0}}

Kind regards,
Bill

Leena Pratheepan

Hi @Rebekka Heilmann _viadee_ It does not work, which means that the custom field "Total amount" in Epic is not overwritten. Instead, "none" always appears after the rule is triggered.

I would like the net values in the childissue to appear in the custom field "Total amount" in the epic.

Leena Pratheepan

Hi @Bill Sheboy

Thank you for your reply. I have tried to rewrite the rule as you suggested. Unfortunately, nothing happens.

The audit log shows that the rule was successful. But only because it removes the value again and reads none.

Leena Pratheepan

Finally it works. Thank you @Bill Sheboy @Rebekka Heilmann _viadee_

Leena Pratheepan

Why does Jira automation set the values back to zero? Can someone explain this? @Bill Sheboy @Rebekka Heilmann _viadee_

Yonghun Jeong

As far as I know, lookupIssues doesn't support customfield. It doesn't even need to mention about sum function.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software-cloud