0

NP UNION not returning complete list

Hi:

i have two filters that separately run and produce proper results.  When I NP Union them to get a combined list some of the results are missing.  I cannot determine why this is happening.

Here are my two filters:

=NL("Filter","Stockkeeping Unit","Vendor No.","Quantity on Hand","<>0","Item No.",$C$4,"Vendor No.",$C$3,"Location Code","SURREY|CALGARY")

=NL("Filter","Purchase Header","Buy-from Vendor No.","Buy-from Vendor No.",$C$3,"Link=","Purchase Line","Document No.","=No.","No.",$C$4,"Type","Item")

 

Here is my union statement:

=NL("Rows","Vendor","No.","No.",NP("Union",$B$10,$B$11))

But when I run the report like 7 vendors are missing but they show up in the Purchase header filter when run on its own.  Is there a reason for this?  I'm not sure how to get an accurate result.  Any help is appreciated.

 

 

 

 

 

0 comments

Please sign in to leave a comment.