There is a limit filter that you can use with rows, but does anyone know if there is a filter or way to return the Nth item from a table or calculation, i.e. 3rd highest sales, that can be used with sum, first and other lookups? Thanks.
Date
Votes
3 comments
-
Jet Reports Historic Posts I'm not sure if I get the meaning of "can be used with sum, first and other lookups" right. But I do know about the Nth item :)
Suppose you want to retrieve 3rd highest sales customer from NAV. The function to do so would be:
NL("3","Customer",,"-Sales (LCY)";"<>0")
With NFs you may retrieve from this record.
The number in the first argument of the NL function refers is what you refer to as the Nth record. You may use both positive and negative numbers - "1" is first, "2" is second, "-1" is last, "-2" second from last etc. etc.
Important here is the sorting. That's why there is a "-" in front of the Sales (LCY) field name.
Is this what you are looking for Afoster? -
Jet Reports Historic Posts Yes, exactly, thank you very much.
-
Jet Reports Historic Posts Great Hans, I've used this for months but didn't knew you could use negative numbers! (always used sorting…)
Please sign in to leave a comment.