Previous Topic: Group the Conditions in an Expression

Next Topic: Apply Named Expressions

Change a Boolean Operator in an Expression

You can change a Boolean operator in an expression by clicking one of the following buttons on the Infix Notation group box in the expression editor:

To change a Boolean operator in an expression

  1. Select one condition or group of conditions by clicking it.

    Note: To select multiple adjacent conditions, hold down the Shift key while clicking.

  2. Click one of the following buttons:

    And/Or

    Switches between the Boolean operators AND and OR.

    Example:

    AND condition_1

    becomes

    OR condition_1

    Note: The AND/OR button switches XOR to AND.

    Not

    Switches between adding and removing the Boolean operator NOT.

    Example:

    AND condition_1

    becomes

    AND NOT condition_1

    XOR

    Switches the Boolean operators AND and OR to XOR.

    Example:

    AND condition_1

    becomes

    XOR condition_1

    Note: The exclusive OR (XOR) operator takes two Boolean operands and returns TRUE if either operand is TRUE, but not both.

    Conditional?YES:NO

    Adds the conditional decision operator.

    Example:

    condition_1

    becomes

    condition_1 ? "YES" : "NO"

    The edited expression is displayed in the fields on the Resulting Notation and Infix Notation group boxes in the expression editor.


Copyright © 2010 CA. All rights reserved. Email CA about this topic