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

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)}:

[Alain_Lapierre]

Thank you very much Tuncay, I'll try that, but it makes sense to check the resolution!!!