New EVALUATE_PREDICATE Function dialog

Use this dialog to create or edit the EVALUATE_PREDICATE function's formula.

For more information, see:

• "How Can I Use the EVALUATE_PREDICATE Function with a Filter?"

• "EVALUATE_PREDICATE"

This dialog is also displayed as:

Edit EVALUATE_PREDICATE Function dialog

Components

Available

Displays the primary subject area and any related subject areas that have been added to the "Subject Areas pane". Use this area to select columns to use in the formula. To insert a column in a formula, select the column and click the Add Column button.

Formula

Use this area to create the EVALUATE_PREDICATE function's formula.

You can enter the formula manually or use these components:

• Variable > — Use this button to select the type of variable (Session, Repository, or Presentation) to add. The "Insert Variable dialog" is displayed, where you specify the name of the variable.

• + — Use this button to insert the addition operator to add values.

• - — Use this button to insert the subtraction operator to subtract values.

• x —Use this button to insert the multiplication operator to multiply values.

• / — Use this button to insert the division operator to divide values.

• % — Use this button to insert the percent sign to divide values by 100.

• ( — Use this button to insert the left parenthesis to enclose data in brackets.

• ) — Use this button to insert the right parenthesis to enclose data in brackets.

• ||— Use this button to insert the concatenation operator.

Notes

To manually enter a variable in an expression in the Formula area, follow the guidelines for referencing variables in expressions described in Table 2-2.