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

Error: Empty Filter Not Allowed


Overview

Sometimes you want to filter an NL function based on the contents of another cell or the output of another NL function, where either of which could be a blank value.

The NL function does not allow you to use blank filters, and you will get a #VALUE and error message when you run the report.

empty-filter.png

 

Resolution

See the article for Referencing a Blank Cell using @@.

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

Comments