Unique record in expression

[alerse]

Hi

Do you know how to get the last record out of a table to use in an expression?

I've got a table that looks something like this:

L1 L2 Month Actual

Lev1 200906 45.4

Lev1 200905 32.3

I've got this in my help text expression:

=Maxstring(If([L1] = VarL1Out and Isnull([L2]),[Actual]))

How can I get the record for the latest month?

Thanks!

Eon

[stephencredmond]

Hi,

Have you looked at FirstSortedValue:

=firstsortedvalue(Actual, -Month)

Regards,

Stephen

[alerse]

Hi Stephen

Thank you for your input! I couldnt get your solutionto work... I've decided to go a totally different route... I've added actions to Select in field the values I nede to filter on

Regards,

Eon