Skip to main content

Is there a simpler and cleaner way to execute this Filter Logic within a report:

 

(1 AND 2 AND 3) OR

(1 AND 2 AND 4) OR

(1 AND 2 AND 5 AND 6) OR 

(1 AND 2 AND 7 AND 8) OR

(1 AND 2 AND 9 AND 10)

 

I need conditions 1 and 2 to be true throughout the report. I feel like there should be a way to declare that at the start and not include them with every other part of the logic. 

3 个回答
  1. 2023年5月25日 20:11

    @Jeremy Cooper Try the following...

     

    (1 AND 2) AND ((3 OR 4) OR (5 AND 6) OR (7 AND 8) OR (9 AND 10))

     

    You Owe Me A Sea Urchin 🤣