0

Filter Using Or

Jet Reports Historic Posts

July 12, 2013 16:14

None

Follow

Hello,
I am having trouble using a filter where I need to look at 3 different variables and if any of them contain a value other than 0 I want to pull in the item number from the database. Below is what I came up with but this will only pull in the item where all 3 values are not equal to 0. Is there a way to use some type of "or" operator that will look at each variable individualy? The variables are qty_on_hand, qty_alloc_co, and qty_wip.

=NL("rows","itemwhse","item","item",NL("Filter","itemwhse","item","qty_on_hand","<>0","qty_alloc_co","<>0","qty_wip","<>0"),"Link=","item","item","=item","product_code","<2000","stat","A")
Thank you!
Mark

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts July 12, 2013 16:36 Official comment

  Hi Mark,
  
  You actually need to use an NP(Union) for this. It would look something like this:
  
  =NL("rows",NP("Union",NL("Filter","itemwhse","item","qty_on_hand","<>0","Link=","item","item","=item","product_code","<2000","stat","A"),NL("Filter","itemwhse","item","qty_alloc_co","<>0","Link=","item","item","=item","product_code","<2000","stat","A"),NL("Filter","itemwhse","item","qty_wip","<>0","Link=","item","item","=item","product_code","<2000","stat","A")))
  Does this help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts August 19, 2013 14:09

  Thank you Hughes, that worked wonderfully.
  
  Sorry it took so long to give you a response!