Display Max(Date) where associated field is not null

[#1]

Hello lovely people

ID	Date
-	03/07/2015
-	02/07/2015
-	02/07/2015
145A	01/07/2015
268B	01/07/2015
3092D	30/06/2015

I would like to select the last record date where the ID isn't NULL.

I can do it in a chart, but I need to do it in a text box and can't for the life of me work it out.

Help!

[Gabriel]

Hi,

Try this

=Date(Max(Aggr(Date(Date),ID,Date)))

[antoniotiman · Accepted solution]

Hi Lewis,

=Date(Max({<ID={*}>} Date))

or

=Date(Max(If(Not IsNull(ID),Date)))

Regards,

Antonio

[MarcoWedel]

=FirstSortedValue({$<ID={"*"}>} distinct Date,-Date)

hope this helps

regards

Marco

[#5]

Thanks for your help chaps.

[#6]

Thanks for your reply Gabriel. However, this gives me the last date in the table, regardless of whether the ID is null or not.

Do you have any other example that could satisfy this problem, but still use AGGR? I'm keen to get to grips with that function.