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 · Accepted solution]

Hi, @jeromey suko 

Please, try this formula:

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

[jeromey suko]

Great! Worked perfectly, thanks. 

[Evgenii]

Please, accept answer, if you don't mind. It will help other people with similar questions