Boolean Operators

AND
joins two conditions and returns true if both conditions are true.
For example,
(1 = 1) AND (2 = 2)
returns true, and
(1 = 1) AND (2 = 1)
returns false.
IF... ELSE
returns different values, depending on whether the condition is true. The first parameter specifies the condition. The second parameter specifies the value to return if the condition is true. The third parameter specifies the value to return if the condition is false.
For example,
if (X > Y) return X else Y
returns the value of X if X is greater than Y, but returns the value of Y otherwise.
Note: Starting in the 7.1 release, the IF... ELSE operator can also be used in report filters in the designer.
NOT
returns true if the condition is false.
For example, not (1 = 2) returns true.
OR
joins two conditions and returns true if either condition is true.
For example,
(1 = 1) OR (2 = 2)
returns true, and
(1 = 1) OR (2 = 1)
returns true.
Last updated: January 8, 2019