Database Tab - Calculation Editor Dialog

Use this tab when building a field calculation. The Working Papers and Time databases that can be used are listed to simplify the process of selecting the appropriate field.

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.

Database

Select the Working Papers or Time database to view. Its fields will be displayed in the Field Name window. As each field name is selected, information about it will be displayed in the description box at right.

AM

If selected, a list of fields from the Trial Balance database is displayed.

SH

If selected, a list of fields from the Document Manager database is displayed.

MP

If selected, a list of fields from the Mapping database is displayed.

Field Name

Double-click a field to insert it into the function.

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 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