0

Jet Reports - How to use separate filters OR

VK

August 06, 2021 23:49

None

Follow

Hi I am trying to create a jet report where it pulls all items with a starting date and and ending date. 

I want to create a filter with both the starting date and ending date mutually exclusive and not together. 

For example, I want all items starting with date 01/01/2021 and all items ending 01/01/2021, but both would have different items reported. I don't want a report where both filters apply. I would like a report where both filters either starting or ending date = 01/01/2021.

Hope that makes sense. Thank you!

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Rob Fontaine September 02, 2021 18:09

  Hi VK,

  Without knowing the exact structure of your table such as field names, here's a general idea of how you might be able to do this:

  Cell B2 - NL("Filter","Item","No.","Starting Date","01/01/2021")

  Cell B3 - NL("Filter","Item","No.","Ending Date","01/01/2021")

  Cell B4 - NL("Rows","Item","No.","No.",NP("Union",$B$2,$B$3)) to list all item numbers

  or

  Cell B4 - NL("Rows","Item",,"No.",NP("Union",$B$2,$B$3)) to list all item records and then use NF formulas to pull data for specific fields.