Summing children in a structure formula if a condition is met

jeromey suko

Hello, 

I am trying to sum the story points of child tasks if a certain status condition is met. I am successfully able to sum the children for all status types, but want to limit based on status. I am trying something like this:

IF (type=Capability and status not in (Funnel, Elaborating);

    sum#children{elaboratedStoryPoints};

)

Evgenii

Hi, @jeromey suko 

Please, try this formula:

IF (JQL{issuetype=Capability AND status not in (Funnel, Elaborating)}): sum#children{elaboratedStoryPoints}