Articles in this section

See more

Null values for aggregate tree properties

Avatar
Ac
Updated
Follow 

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

Sort by Date Votes
  • Avatar
    Ac

    Shame I can't do arithmetic! That should be 50 points of course.


    Foot in mouth

    0
    Comment actions Permalink
  • Avatar
    Joshua R Cronemeyer

    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.

    0
    Comment actions Permalink
  • Avatar
    Huimin Li

    Hey Andy:


    The "configurable formulas" is available in Mingle 3.3.1 now. 


    Thanks.


    -- Huimin

    0
    Comment actions Permalink

Please sign in to leave a comment.