Open Plan 8.8 Help

Calculated Fields

Use the Calculated Fields option on the Tools tab to define a new calculated field.

When you define a new calculated field, Open Plan displays the New Calculated Field dialog box where you can enter a name for the field, the data table to which you want to associate the field with, and the type of result produced by the field.

After adding a name, data table association, and result type, Open Plan displays the Calculated Field Expression dialog box where you can enter the expression for the field.

You can change the table and data type assignment for the expression. For expressions that result in decimal data types, you can specify the number of decimal places in the result.

You can define calculated fields for both project and resource files. By default, Open Plan stores the calculated field with the project or resource file that is open when you define the field. Open Plan may also store the field with the current view if the field is used by the view.

Types of Calculated Fields

The calculated field can produce any of the following result types:

Field Description
Character Returns a character string to the calculated field
Date Returns a date to the calculated field
Decimal Returns a decimal number (for example, 7.89) to the calculated field
Duration Returns a duration to the calculated field
Finish Date Returns an activity Finish Date to the calculated field
Integer Returns a whole number to the calculated field
Logical Returns a True or False value to the calculated field