0

How to set an OR condition on a filter?

Jet Reports Historic Posts

July 13, 2017 17:20

None

Follow

Hello,
How do you set an OR condition on a filter?
I want to return rows of work orders where the column 'batch owner' = "AAA" OR the column 'new batch owner' = "AAA"? Can this be done with an NL Rows?

I have this formula
=NL("Rows","Posted work order line","document no.","work order date",$C$2,"batch owner",$C$3)
but I need to also include rows where "new batch owner" = $C$3

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Jet Reports Historic Posts July 13, 2017 20:05

  Hello -
  
  The easiest method, of course, is to use two NL("Rows") functions - one filtered by Batch Owner and the other by New Batch Owner.
  
  In situations where the results must be returned by a single function, you could accomplish that with something like this:
  
  =NL("rows","Posted work order line","document no.","=OR(NF(,""Batch Owner"")=""AAA"",NF(,""New Batch Owner"")=""AAA"")","@TRUE")
  Another option would be to use two NL("Filter") functions to create two lists of document numbers. Then use the NP(Union) in your NL(Rows) to show the results.

• 0
  
  Jet Reports Historic Posts July 14, 2017 15:13

  Thank you for showing me how to use the OR condition!
  I accomplished what I needed by using two NL filters, but without the NP union. This is what worked for me:
  
  =NL("Rows","posted work order line",,"document no.",NL("Filter","Posted Work Order Line","Document no.","current batch owner",$C$2),"document no.",NL("Filter","Posted Work Order Line","Document no.","new batch owner",$C$2))