Hello,
Can someone tell me how to exclude a list in the filtering criteria. Let's say I have a list of employees who do Journal Entries but I want to exclude multiple employees from the report. How can I do that in the options? Thanks.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hello,
If the list of Employees you want to exclude is relatively short, you can just construct a filter like this:
<>Employee1&<>Employee2&<>Employee3
If you have a longer list of employees or exclude or if you want to get the employees to exclude from the database, you can use NP(Difference). For example, to exclude all employees whose names started with A or B, you could do this:
=NL("Rows",NP("Difference",NL("Filter","Employee","Code"),NL("Filter","Employee","Code","Name","A..C")))
Does that help?
Regards,
Hughes -
Jet Reports Historic Posts How would you go about excluding an excel list of specific employees (possibly hundreds of unique values)? Is this possible?
-
Jet Reports Historic Posts See the attached file for an example. I ended up with this: =NL("rows",NP("difference",F10:F15,G10:G11))
F10:15 is the master list
G10:G11 are the values I want to exclude
Please sign in to leave a comment.