Forum Discussion
Sum not working
I have been using this below to calc when an item is PAST the Sprint End Date compared to the Closed Date? this calc doesn't seem to work for some reason....it won't sum like all the other columns I'...
Hi Anonymous ,
Notice that your formula has a [Story Points], but I can't see this column or measure in the screenshot of the table.
Could you please tell me how to calculate this and whether the Story Points Done Late is a column?
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yinliw-msft Greg_Deckler It is a calculated column for Story Points Done if that helps
Sprint Done Points = IF('Sprint Burndown'[Date].[Date] = 'Sprint Burndown'[Sprint End Date].[Date] && 'Sprint Burndown'[State] IN {"Done","UAT","Closed"} , 'Sprint Burndown'[Story Points],0)