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

Using more than 10 filters in an NL() function


Overview

Under typical usage, you can employ up to 10 filters in a single NL() function - e.g., NL("Rows") and NL("Table")

Occasionally, you may want to use more than 10.

 

Example
(note: this won't work)

=NL("Rows","Customer",," No .","10000..99999"," State ","CA"," Tax Area Code ","CA"," Statistics Group ","0", Tax Bus. Posting Group ","*", Tax Identification Group ","Legal Entity", Tax Liable ","False"," Territory Code ","*"," UPS Zone ","*"," Zip Code ","*"," Shipping Agent Code ","*"," Salesperson Code ","PS")

 

 

FILTERS=

To accomplish this, you can use the special filter "FILTERS="

Here is what that looks like:

Using two columns, you list the Fields you want to use in the first column and the Values for those fields in the second column. You then use "FILTERS=" in your NL() function and reference the range of cells containing your filters.

 

This technique can be used in conjunction with other special filters, such as "LINK=":

 
 
Note that the Table Builder uses this method automatically:
 
 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments