Calculate Story Points committed MINUS story points that spillover from Previous Sprints

[janis.plume]

Hi,

There is a similar post for counting the spill-over issues:

Total Number of Carried Over In Sprints

Hello, I’m having a hard time calculating the total number of Carried overs that existed in a given Sprint. I can already individually have the number of each of the carried overs with the formula: IIf(Count([Sprint].[Sprint].getMembersByKeys( [Issue].CurrentHierarchyMember.get(‘Sprint IDs’))) > 1, 1, 0) But I cannot specifically calculate that a given Sprint had x carried overs.

We can replace the “1” with the story points count:

Sum(
  Filter(
    DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),
--property includes multiple IDs - looking for the comma    
   CoalesceEmpty([Issue].CurrentHierarchyMember.Get('Sprint IDs'),'') MATCHES '.*,.*'
  AND
--property contains the ID of the current sprint  
    CoalesceEmpty([Issue].CurrentHierarchyMember.Get('Sprint IDs'),'')
    MATCHES 
    '(^|.*,)'||Cast([Sprint].CurrentHierarchyMember.Key AS STRING)||'(,.*|$)'),
  [Measures].[Issue story points]
)

Kindly,

Janis, eazyBI support