Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
See qv attached i explained more.
Rgds
Ema
try this expression in textbox
=if(
GetSelectedCount(Date)=1,
Only(Comment),
Only({$ <Date={'$(=max(Date))'}>} Comment)
)
try this expression in textbox
=if(
GetSelectedCount(Date)=1,
Only(Comment),
Only({$ <Date={'$(=max(Date))'}>} Comment)
)
Or just
=Only({<Date= {'$(=Date(max(Date)))'}>} Comment)
Make your Text Object expression
=FirstSortedValue(Comment,-Date)
-Rob
Or even this
=FirstSortedValue(DISTINCT Comment, -Date)