Variables Tab - Calculation Editor Dialog

Variables are CaseView items that hold values. These include Cells, User-defined Data, and Sum Groups. They may be entered in calculations as expressions or parts of expressions.

For example, the condition function

IIF(c3030>0,c3030,0)

Looks at the contents of cell 3030 (the variable) and answers with the value of cell 3030 if it's greater than 0, or 0 if it's less than or equal to 0.

Calculation

The box displays the working version of the calculation.

Note:

• Click the word "Calculation" to open the Calculation Explorer window.

Calculation Result =

The cell contents resulting from the calculation are shown.

Variable Categories

Select a category to display in the Variables box. As you click on each variable, information about it is displayed in the description box at right.

User-defined Data

Select User-defined Data and then select a link code as entered in the User Defined Data dialog for the current document.

Engagement Properties

Select Engagement Properties and then select an Engagement Properties (CLP) code from the list. Details about each code are displayed to the right as you click on it.

Cells

Select Cells and then select a cell number from the list of all cell numbers used in the current document. As you click on each cell number, details about it are displayed to the right.

Sum Groups

Select Sum Groups and then select a sum group number from the list of all the sum groups used in the current document. As you click on each sum group, a listing of the cells included in the group is displayed to the right.

Variables

Double-click a Variable to insert it into the Calculation box.

To insert a logical function into the calculation at the cursor point, click the appropriate button.

File

Click the File button to insert a file path into the calculation. The path will be contained in quotes, as required by calculations.

When you click File, the Open dialog will appear allowing you to browse to the target file. Select the target file and click Open. The file path will be automatically inserted into the calculation at the cursor point.

Related Topics

• Calculation Editor