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 |