How to get a sum of an epics original estimate including its storys and subtasks

Question

I need to get the sum of an epic (and its story's and subtasks) original estimate. I would like to exclude issues with status "cancelled" but all other statuses I need to include.

I use the role up function in advanced roadmaps when looking for a sum of an epics remaining estimate. But it is not possible to do the same with the field "original estimate".

Any idea on how I get the sum?

Sayed Bares [ServiceRocket] · Answer

@Jane_Rasmussen-CIC I believe https://community.atlassian.com/t5/Jira-Software-articles/Calculate-the-sum-of-original-estimates-of-all-issue-types-to-an/ba-p/1660572 answers your question. You'd need an Issue fields condition to exclude issues in cancelled status. Hope it helps!