Sum of completed points in an Epic

Alain.Lapierre

Hello, 

I am new to formulas and Structures in general, and I am trying to put in a variable the number of closed points in an epic, but I can't seem to figure it out, I feel like I am far from the right answer, can someone help me?

What I have so far is:

with NbPtTotal = SUM#children{storypoints}:

with NbPtDone = if(Status = "Done"; StoryPoints; 0):

Tuncay Senturk

Hi @Alain.Lapierre 

Welcome to the Community!

I am not an expert on this, could you please try this?

with NbPtTotal = SUM#children{StoryPoints}:
with NbPtDone = SUM#children{if(Status = "Done"; StoryPoints; 0)}:

 

NbPtTotal calculates the total story points in all child issues.

NbPtDone calculates the sum of story points for issues where the status is "Done."

or you can use resolution field to calculate resolved issues (whatever its final status is)

with NbPtDone = SUM#children{if(Resolution != ""; StoryPoints; 0)}: