Structure: How do I get the sum of the child issues with the same team?

[Diana]

I'm trying to get the sum of story points, but only if the parent issue and the child issue are assigned to the same team. See screenshot example. 

I have the structure grouped by team. Feature 4 is assign to Team A and it has 5 child stories. But there's 1 story assign to Team B. 

How do I get the formula to work so that Team A total story points reads as 10 and not 11?

Currently my formula:

[Uday Kiran Bhaviri · Accepted solution]

Hi @Diana Gorv 

I think you can check for condition if Custom Team = "Team A" then sum up all points.

[Diana]

@Uday Kiran Bhaviri Thanks for the quick response.

Unfortunately, that won't work. The formula needs to grab whatever is the parent's team and check to see if its child issue are also the same team, because we're looking at more than just Team A. 

See this screenshot example:

For the grouping in Team B as an example, Team B's should total to 4 points if we exclude the story that's assign to Team D. 

Basically, I'm trying to get the formula so that if the parent issue and its child issues are the same team, then add up the story points.

[Stepan Kholodov _Tempo_]

Hello @Diana Gorv 

You can try adding this part in front of your original formula:

if customteam = parent#level=-2{summary}: 

the formula will check if the Custom Team value of an issue matches the name of the group it's placed in and if it does, then the formula will extract Story Points of linked issues. Please note that the hierarchy matters in this case - the formula specifically references the level of the parent, so it would need to be changed if the hierarchy changes.

I hope this helps. Please reach out to us directly at our support portal if you need help with Structure in the future.

Best regards,
Stepan
Tempo (the Structure app vendor)

[Diana]

@Stepan Kholodov _Tempo_ 

Thank you! This is exactly what I need.

Final formula is:

if customteam = parent#level=-2{summary}:

issueLinks.MAP( 
IF($.type='derivation' AND $.source.team = $.destination.team, 
storypoints))

With option 'Sum over sub-items' checked.