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; } } }

Sum issues in epic

Lana Kelly

Hello everyone,

I'm back with another automation question 😅. I've read all the suggested posts and they make sense, but there must be some small error I'm making that I'm not noticing.

We have an epic which has a custom field called "Residual Quantified Risk." Every issue in the epic has a field called "Quantified Risk." I want to sum the Quantified Risks from the issues into the Residual Quantified Risk in the Epic. This is what I have so far. The audit log says only "config change," even though I've tried to trigger it many time.

Thank you again for your help!

Accepted answers

Bill Sheboy

Hi @Lana Kelly

Your rule is referencing a Lookup Issues result to sum the field, but your rule does not have a Lookup Issues action.

Please add that action, with the JQL to gather the children of the epic, before your edit and the rule will work as you expect.

Kind regards,
Bill

Lana Kelly

Good morning from blustery Finland! It is definitely the right audit log, and it's a company-managed project.

Screenshot 2023-09-26 at 9.09.38.png

I already tested changing the editing part, so that changing the QR would change the summary, and that worked. It's just the part where it sums the QRs in the RQR field that doesn't work.

All comments

Jack Brickey

Hi @Lana Kelly , could you please share an image of your rule?

Lana Kelly

Ah, sorry. I thought they had attached, but apparently not. Screenshot 2023-09-25 at 14.40.06.png Screenshot 2023-09-25 at 14.34.58.png

Jack Brickey

Thanks. So you are saying the rule is not triggering, correct? Is this a single project rule and are the issues in the same project? I assume there is only one "quantified risk" field in your instance (just want to rule that out as the problem)?

while we are trying to resolve the trigger issue you might test the rest of your rule by changing the trigger to manual temporarily.

Lana Kelly

I changed it to manual trigger, and it says success, but it hasn't updated the field. It's a single project rule and all the issues are in this project, yes. And there is only one "quantified risk" field, which is a number field (same for "residual quantified risk")

Bill Sheboy

Hi @Lana Kelly

Your rule is referencing a Lookup Issues result to sum the field, but your rule does not have a Lookup Issues action.

Please add that action, with the JQL to gather the children of the epic, before your edit and the rule will work as you expect.

Kind regards,
Bill

Jack Brickey

agreed and that was my next comment but then I also saw what I thought led me to my last inquiry on TMP vs. CMP. I wanted to provide a full working example but needed that bit first.

Lana Kelly

Good morning from blustery Finland! It is definitely the right audit log, and it's a company-managed project.

Screenshot 2023-09-26 at 9.09.38.png

I already tested changing the editing part, so that changing the QR would change the summary, and that worked. It's just the part where it sums the QRs in the RQR field that doesn't work.