topic Re: Display only row with latest date in Straight Table in App Development

Display only row with latest date in Straight Table

Brip51 — Wed, 04 Oct 2023 20:01:28 GMT

Hi,

I have a straight table that can have rows with the same "Table Name" (1st col), but they can have different update dates.

I am trying to figure out how to display only the latest updated date . In the sample below the table named 'Ultimate Loss Ratio (excludes ULAE)' has two Updated Dates. I want to only display the 10/02/2023 date row.

I have been struggling to figure out how to do this. I tried FirstSortedValue, but that didn't work.

Any ideas on the best way to do this would be greatly appreciated.

Thanks,

Brian

Re: Display only row with latest date in Straight Table

tincholiver — Wed, 04 Oct 2023 20:14:39 GMT

Did you try using max(Date) ?

Re: Display only row with latest date in Straight Table

Brip51 — Wed, 04 Oct 2023 20:31:05 GMT

Hi,

Yes. That doesn't display only the row.

Thanks,

Brian

Re: Display only row with latest date in Straight Table

pallavi_96 — Thu, 05 Oct 2023 09:07:18 GMT

Hi,

You can try below expression :

Aggr(Max(Date),Table)

FirstSortedValue(Date(Date,'DD-MM-YYYY'), Aggr(Max(Date), Table))

Re: Display only row with latest date in Straight Table

Brip51 — Thu, 05 Oct 2023 11:58:07 GMT

Hi,

Yes. That worked. Thank you for the help on this !!!

Regards,

Brian