Adding and Deleting Constants

You can create any number of constants that can be referenced when defining formulas, conditional formulas, groups, reports, conditional formats, chart rules, and in the search panel.

To add a constant:

1        Click the Home tab and select Define Constants from the Fields & Formulas section.

The Define Constants dialog box is displayed.

2        Click Add. A constant is added.

3        Name the constant by entering a name into the Name column.

4        Set the field type by selecting from the Type drop-down list for that constant. The following options are available:

·         Text

·         Date

·         Number

·         Percentage

5        Enter a value for the constant into the Value column. 0

To edit a constant:

1        Click the Home tab and select Define Constants from the Fields & Formulas section. The Define Constants dialog is displayed.

2        Click in the Value column associated with a constant.

3        Edit the value for that constant as needed.

Note: You can rename a constant by clicking in the Name column or change the type using the Type drop-down list. 0

To delete a constant:

1       Click the Home tab and select Define Constants from the Fields & Formulas section.The Define Constants dialog is displayed.

2        Select a constant by clicking in the first column associated with that constant.

3        Click Delete. A warning message is displayed asking you to confirm that you want to permanently delete the constant. Click Yes to delete or No to cancel the action.  All references to constants will be replaced by the last value stored in the constant. 0