Sum and Division to Edit Parent Issue

Question

I have created a rule that should calculate the total sum of 2 separate fields (story points and "progress(%)") the result should appear in two new fields with the prompt "Total xxxxx" of each one, then I should divide those total values ​​to send them to a field in the parent issue "HU - Progress(%)". My problem is that the "Total" fields are edited to "0" therefore they do not edit the "HU" field.

the customfield are Numeric type.

Enmanuel V_ · Answer

Hi Bill, i didn't know that, thank you so much for your support, i will try to apply you option and see how it goes!

Bill Sheboy · Answer

Hi @Enmanuel V_ -- Welcome to the Atlassian Community!

With Jira Data Center automation rules, the Lookup Issues action currently only supports a few fields, and it does not support custom fields: https://confluence.atlassian.com/automation/jira-smart-values-issues-993924860.html#Jirasmartvaluesissues-lookupissues-properties

Here is the suggestion to add those other fields, which you may watch / vote for to see progress: https://jira.atlassian.com/browse/JIRAAUTOSERVER-877

For your scenario, a workaround is: instead of using Lookup Issues, use the REST API to call an issue search with the same JQL, using the Send Web Request action.  Then the fields could be summed from the web response.

If you want to try that approach, here is a how-to article for calling a REST API function from a rule and the function I believe is needed:

* https://community.atlassian.com/t5/Jira-Software-articles/Automation-for-Jira-Send-web-request-using-Jira-REST-API/ba-p/1443828
* https://docs.atlassian.com/software/jira/docs/api/REST/9.13.0/#api/2/search-search

Kind regards,
Bill