Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet Reports Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Using NL(Filter)


The following formula will retrieve a list of records from the Orders table:

=NL(“Rows”,”Orders”)

NL(Filter) can be used to filter on a field that is not on the Orders table (such as the "Subtotal" field on the “Order Subtotals” table) as follows:

=NL("Rows","Orders",,"OrderID",NL("Filter","Order Subtotals","OrderID","Subtotal",">100"))

There is one NL function inside another. The inner NL function returns an array of the values of the OrderID field where the value of the Subtotal field is greater than 100. Jet can use this array as a filter for the Orders table.

 

Note:  The NL(Filter) function can also be placed in its own separate cell and referenced from the NL(Rows) function.

Was this article helpful?
1 out of 2 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    Trezor Owens

    Can you give an example of how to do:

    Note: The NL(Filter) function can also be placed in its own separate cell and referenced from the NL(Rows) function.

    I've been trying that without intuitive success.

  • Avatar
    Harry Lewis

    Cell D5: =NL("Filter","Customer","No.","Name","A*")

    {a list of all customer numbers where the customer name starts with the letter A}

    Cell D6: =NL("Rows","Cust. Ledger Entry",,"Customer No.",$D$5)

    The function in sell D6 will list out all Cust. Ledger Entry records where the customer number is contained in the list in cell D5.

    This is a simplistic example, but explains how to use this.