Configure Logical expression
Functions
AND
| Syntax | (expression1) AND (expression2) |
| Description | Returns true if both the expressions evaluate to true. |
| Example | IF([CustomerID]='VINET' AND [OrderID]='10248', [Discount], [Discount]+0.1) |
NOT
| Syntax | NOT(expression) |
| Description | Returns the reversed logical value of the expression being evaluated. |
| Example | IF(NOT [CustomerID]='VINET', [Freight], [Freight]-100) |
OR
| Syntax | (expression1) OR (expression2) |
| Description | Returns true if any of the expressions evaluate to true. |
| Example | IF([CustomerID]='VINET' OR [OrderID]='10248', [Discount], [Discount]+0.1) |