I am creating a report for checking the % of completion of committed work with the formula of:
[Measures].[Sprint issues completed of committed]
/
[Measures].[Sprint issues committed]
That’s easy. However, I found that “Sprint issues committed” default formula appears as null and checking with the Sprint Report in JIRA, it can’t be because the Sprint was:
committed issues = 13
removed = 1
added = 4 (those with an asterisk)
completed = 10 (8 out 10 from the committed)
So, the formula should be:
completed= 8 / committed = 13
Thanks for sharing the screenshot of your report. It looks like you are filtering the report by Current Quarter, but the issues committed to the particular sprint happened in previous Quarter. Can you try selecting anther Time period in the Time filter that would also include previous Quarter and see if the measure “Sprint issues committed” return any results for the particular sprint?