Define Cross-Variable Rules

The Cross-Variable Rules tab allows you to create, view, and modify cross-variable validation rules.

Rules. The list shows cross-variable validation rules by name. When the dialog box is opened, it shows a placeholder rule called "CrossVarRule 1." The following buttons appear below the Rules list:

  • New. Adds a new entry to the bottom of the Rules list. The rule is selected and assigned the name "CrossVarRule n," where n is an integer so that the new rule's name is unique among single-variable and cross-variable rules.
  • Duplicate. Adds a copy of the selected rule to the bottom of the Rules list. The rule name is adjusted so that it is unique among single-variable and cross-variable rules. For example, if you duplicate "CrossVarRule 1," the name of the first duplicate rule would be "Copy of CrossVarRule 1," the second would be "Copy (2) of CrossVarRule 1," and so on.
  • Delete. Deletes the selected rule.

Rule Definition. These controls allow you to view and set properties for a selected rule.

  • Name. The name of the rule must be unique among single-variable and cross-variable rules.
  • Logical Expression. This is, in essence, the rule definition. You should code the expression so that invalid cases evaluate to 1.

Building Expressions

  1. To build an expression, either paste components into the Expression field or type directly in the Expression field.
  • You can paste functions or commonly used system variables by selecting a group from the Function group list and double-clicking the function or variable in the Functions and Special Variables list (or select the function or variable and click Insert). Enter values for any parameters indicated by question marks (applies only to functions). The function group labeled All provides a list of all available functions and system variables. A brief description of the currently selected function or variable is displayed in a reserved area in the dialog box.
  • String constants must be enclosed in quotation marks or apostrophes.
  • If values contain decimals, a period (.) must be used as the decimal indicator.