JIRA Structure - Sum over Subitems for formula field for a project schedule

[Lexi]

I created a column that gives me the number of days of effort left on a task based on the remaining estimate field. this is working great. i am summing over subitems so that i can tell for the parent groupings i creating how may days of effort are left for the overall period.

the problem i am running into is that if the remaining estimate is filled out on a subtask, it also disaplys on the parent, which is then summed and doubling the data

example:

one task A with a subtask of B

subtask of B has 24hs (3days)

this shows on the parent task as well (just how jira works) so task A has 24hrs as well (3days)

this means that in structure, task A shows 6 days when really there is only 3 days of work left.

how do i fix this? I want to see that April-May 2023 only has 3 days of effort left.

[Lexi · Accepted solution]

i think i may have found a change that works by adding to my IF statement "if issuetype != subtask" - still investigating and open to any other suggestions

[David Niro]

@Lexi , this would be my suggestion as well.  Is it working for you?

[Aykhan Mustafayev]

up