Fetching 5th last value from column?

[Anonymous]

Hi experts..

How to fetch 5th last value from column in frontend using aggr() & without Max().

Plz help its urgent.

Thanxx in advance.

[jagan]

Hi Sonal,

Try

=FieldValue('FieldNAME', 5)

Hope this helps you.

Regards,

Jagan.

[Gysbert_Wassenaar]

What does '5th last value' mean? By order of the values or by row number? min(Value, 5) or bottom(Value, 5)?