ALM structure formula to select MAX date from a date field of the children with criteria.

[Mark Girgis]

Hi All, 

I am trying to create a formula field in a structure  view that selects the MAX date from the children that match a selection criteria. 2 examples: 

Any ideas if this is possible and what the Syntax would be?

1.  StructureFormula  = MAX{ChildDateField} where child issuetype is Task

OR

2. StructureFormula  = MAX{ChildDateField} where child custom_field = "ABC"

Thanks in advance for any help

Mark

[Vlad Lessage]

Hi Mark,

I know you also created a Service Desk ticket on our Support portal the same day you posted this but I wanted to still answer here for the benefit of other users with a similar scenario. The following Formula will help achieve the desired outcome:

MAX#strict{IF(issueType="High Level Design";BaselineFinish;0)}

I hope this helps.

Best Regards,

Vlad

[ALM Works]