Sum value of same custom field
Hello,
I created an automation rule that when I create an issue that has a particular request type, I execute a JQL query in a branch rule/related issue and then I'd like to sum the values of a custom field that are retrieved by the jql; so, I defined a request that has a field name "Numero Prompt" and the JQL that I use is something like this:
"Request Type" = "Requisição Prompt - {{issue.SLA}} (PM)" order by created DESC
where SLA is a custom field that I use; when I execute this query I obatain a number of issue and to see the value for debug I print it in the log; so, for example, to do a test, I created something like this in picture
and then created as I said a branch rule/related issue where I want to sum the values of my custom field, "Numero Prompt"; in my example, from the jql, I obtain 3 issues and I tried to do various things to obtain "Numero Prompt" values sum; I've seen that, first, I retrieve the values of that field with
{{issues.Numero Prompt}}
but also with something like this:
{{#=}}{{issue.Numero Prompt}}{{/}}
or with
{{#issues}} {{Numero Prompt}} {{/}}
In my test the values are 3 and are 22.0,, 31.0 and 10.0 but I can't find how to sum it; I tried to the "sum" word at the end of, for example, the first expression, but nothing.
I don't know how to do this; I found a workaroung with the "lookup issues", but it is limited to search up to 100 issues; with this, I simply write
{{lookupIssues.Numero Prompt.sum}}
and the work is done, but I want to go over the 100 issues limitation.
How can I sum the 3 values?
