Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have 3 numbers
ID Num
1 10
1 60
3 90.
Here for ID 1 i only want to display 60 which is the largest among 10 and 60.How do I do that ?
Thank you.
Not sure, but may be this:
=Aggr(Date(Max([Lease Expiration Date])), AB1Key)
Sorry,but this is giving me the lease exp date instead of ABKey(which is my ID field)