Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have an app that contains two tables, the first one is my transaction table, so I have data for all days and I have another table with comments, this table includes comments for some days, not all. So in my final table, I need to show the latest comment by the client.
In this example for client 123, for the max date (24/07/2024) I need to show the comment from 23/07/2024 at 16:50 because is the latest comment for this day, but it currently is showing null.
How can I force the table to show always the latest comment from the time?
Try this.
=Only(Aggr(FirstSortedValue(comments, -time), Client))
join the 2 tables into single table ,sort the data by using 'time' field,
let vresult=Peek('comments');
after
If(IsNull(comments),'$(vresult)',comments)