I've a problem with aggregates that return "not set" when they sum a value from cards but there are no cards that match the criteria.
Fore example I have an Epic which aggregates the "Story Point Estimates" of child stories. I want a value (if positive) of the difference between the estimate of the Epic and the sum of its children's estimates. Say the Epic's estimate is 80 and the sum of the children is 30, this indicates the team believe they will discover stories worth another 30 points before they're done. Adding the sum of the stories' estimates with these "remainders" will give us the current view of backlog size. Very helpful when breakdown of epics is going on in parallel with sprints.
Unfortunately in Mingle if the aggregate property does not find any cards in the set being added, the value returned for the aggregate is "not set". Differencing this in a formula property will also return "not set".
How can I get a zero in these circumstances rather than a null?
Comments
3 comments
Shame I can't do arithmetic! That should be 50 points of course.
Hey Andy,
Thanks for taking the time to describe your problem. This is something other customers have struggled with too. I have good news and bad news. The bad news is that current and older versions of Mingle can not treat 'not set' as zero for formulas. The good news is that our forthcoming 3.3.1 release makes formulas configurable to allow 'not set' to be treated as zero! 3.3.1 is scheduled to release at the end of June.
Hey Andy:
The "configurable formulas" is available in Mingle 3.3.1 now.
Thanks.
-- Huimin
Please sign in to leave a comment.