Structure Aggregate SUM function returning blank?

Question

I am trying to indicate issues for which a child has a Due Date later than its parent. This is what I tried doing:

1) Added a 'Parent Date' column: PARENT{DueDate}. This seems to work as expected - it displays dates where the parent has a Due Date, and empty/blank where the parent does not have a Due Date.

2) Added a 'Due later than parent?' column:

if(DueDate > parentDate; 1; 0)

and set the parentDate variable to use the formula from the 'Parent Date' column.  This also seems to work as expected - it displays '0' for everything except where an issue has a later date than its parent it displays '1'.

3) Now (I thought this was going to be the easy part) I add an "Invalid child date"

column: SUM{isDateLaterThanParent}

and set the isDateLaterThanParent varaible to the formula from the 'Due later than parent?' column. However, the result is that this whole column is blank.

Any ideas on what is going wrong here?

Thanks!
David

David Doria · Answer

Bummer, it looks like Structure 6.0 requires Jira 7.13 and we are only running 7.2.6 (https://marketplace.atlassian.com/apps/34717/structure-project-management-at-scale/version-history) Any chance you have a different idea how to achieve this same goal of showing issues who have their children with "invalid" attributes relative to their parent?

Stepan Kholodov _ALM Works_ · Answer

Hello David,

The reason for the formula returning no values is the use of the parent{} function - it aggregates values from the top level to the bottom, so the reverse sum{} aggregation can't be used with it.

But in Structure 6.0 we expanded the Formula column's functionality a bit which now allows it to handle certain calculations that it couldn't do before. We would recommend upgrading Structure, it should make your formula work as desired. You can also use a single formula column instead of three with this formula in it:
sum{if(duedate>parent{duedate},1)}

I hope this helps. If you need further assistance, please contact us via support.almworks.com and we'll be glad to look into your use-case deeper and help you.

Best regards,
Stepan Kholodov
ALM Works