AnsweredAssumed Answered

Most recent comment using MAX calculation from related field?

Question asked by KrisYells on May 21, 2016
Latest reply on May 22, 2016 by erolst

Parent table contains a property id.

Child table contains events using conditional value lists. Input by portal. an event set of records contains  Date, Category,  Event and a Comment field.

 

In the parent table, field titled Executive Summary, I need to display the latest dated comment from the Negotiations Category. Inside the negotiations category I have 5 different events. The events can happen at different times and occasionally have multiple occurrences of the same event.

 

I have tried different version of the calculation below and each time all I can get returned is the date.

 

Case(   

Events::Event Category="Negotiations" ; Max ( Events::Event Date) Events::Event Comment;"" )

 

What I'm trying to say with the calculation is if the related event category equals negotiations return the comment from the latest dated event. If no matches are found return nothing.

 

thanks in advance for the help

Outcomes