I'm not completely sure what you want to do. Is it the situation where, for example you want to find an order that has both part A ordered and part B on the same order? An example or that (typed from memory so I apologies for mistakes) would be to use:
NL("Rows",NP("Intersection",NL("Filter","Purchase Line","Document No.", "No.","PartA"),NL("Filter","Purchase Line","Document No.", "No.","ParBN")))
The NL("Filter") functions each return a list of document no.s for each part, and the intersection gives you the list of no.'s that are in both lists. Check on the NP("Intersection") documentation under Array Calculations.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
Does anyone know how you can create a filter that will show not just a range, but two specific items. For example, I'm creating an NL report and one of my filters is Item No. I want to find all documents that contain both the part# for 1 item and the part# for the other item. I'm able to create this in which I can view all documents that contain either of these part#'s but I cannot filter to just show documents that contain both part#'s within the same document. Any help would be appreciated. i attached my file for reference.
Please sign in to leave a comment.