Question

BAQ If/Then/Or Statement

  • 4 October 2023
  • 1 reply
  • 62 views

Hello All,

 

Adding a criteria to a BAQ, and need help on how to. This has to do with two Boolean’s:

 

I want the report to pull all data if Boolean A is False, regardless the state of Boolean B, and If Boolean A is True Boolean B needs to be True.

 

Appreciate the help


1 reply

Userlevel 3

Set your condition to be “BooleanA = true or (BooleanA = false AND BooleanB = True)”

 

There are “parentheses” that you can use to wrap your query parts and achieve the above.

 

Reply