Max Aggr

[Karl_Hart]

I really dont understand the max aggr function and I think i need it.

I have a series of budget amounts entered into our system and I only want to show the most recent one

Project          Timestamp     Budget

Finance          1                    £25,000

Finance          2                    £30,000

Finance          3                    £20,000

Finance          4                    £23,000

So I want to show the budget amount for only the most recent entry (ie the one against timestamp 4 in this case = £23,000)

Any helpers out there?

[MK_QSL · Accepted solution]

=FirstSortedValue(Budget,-Timestamp)

[Karl_Hart]

Thanks Manish, that was simpler than expected