0

-1 fonction

Jet Reports Historic Posts

May 17, 2017 11:55

None

Follow

Hoi Everyone,

Could somebody tell me how to use the -1 fonction in combination with a date filter?

Thx!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts May 17, 2017 15:33

  Hello -
  
  The NL("Last") function ("-1" is something of a "shortcut") is very simple to use. The one thing to remember is that you need to define what you mean by "last" by defining a sort.
  
  Let's assume that I want the last record - as defined by the date on that record.
  
  I have this table:
  
  
  I can define an NL("Rows") function that lists all records for the month of January:
  
  
  and get this results:
  
  
  I can also define an NL("Last") function - using a sort on the Date field to define what I mean by "last" for those records from January:
  
  
  And I get this result:
  
  
  Jamie's record is the last record for January when I perform an ascending sort on the date.
  
  I hope that helps.