Aggregate Numeric fields of Subtasks

[Ray Balmeo Cagayon]

I have generated automation to create subtasks and assign test hours per subtasks.

1. Task 1 - 4 Hours (Under Custom Numeric Field)
2. Task 2 - 3 Hours (Under Custom Numeric Field)
3. Task 3 - 6 Hours (Under Custom Numeric Field)
4. Task n - 4 Hours  (Under Custom Numeric Field)

As the Tasks get completed, I will need to re-assign the values to Zero (0).

What I wanted to do is to calculate the sum of this hours and calculate it against a predetermined date and see if there is a risk of missing it.

is there a possibility to calculate the agregate of these numeric fields and add this to the current date and time to see if i still fall below my target date?

I only have one Custom Field (Test Hours) assigned to the subtask.

[Bill Sheboy · Accepted solution]

Hi @Ray Balmeo Cagayon -- Welcome to the Atlassian Community!

You mention automation, and so I am assuming you mean automation rules.

You also note both Task and Subtask issue types:

• for subtasks, you could gather and sum the values with {{issue.subtasks.yourField.sum}}
• for Tasks, you could use the Lookup Issues action with JQL to gather the issues, and then sum the field with {{lookupIssues.yourField.sum}}

Once the sum is available, that could be added to dates using the various increment functions:

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-plus-unit---

Then your rule could use conditions for the tests you describe:

https://support.atlassian.com/cloud-automation/docs/jira-automation-conditions/

Kind regards,
Bill

[Ray Balmeo Cagayon]

@Bill Sheboy

Thank you. I will give it a go.