Deltek Open Plan Help

Using the Help Search

Contents of the Calculated Field Expression Dialog Box

Use this fields and options to configure the Calculated Field Expression dialog box.

Contents

Field	Description
Name	When you are creating a copy of an existing calculated field, use this field to enter a new name for the copy. When you are modifying an existing calculated field, this field is disabled.
Expression	This box displays the expression that defines the calculated field or global edit you selected in the [Results] field on the Calculated Fields dialog box. The expression can include the following elements: Character operators Constants Duration operators Field names Functions Logical operators Mathematical operators Calculated fields Relational operators When you modify the criteria of a calculated field, the expression also changes. You can use this box to enter additional expression elements manually. For more information, see Expression Elements. Note: When Open Plan displays an error, the portion of the failed expression is highlighted.
Applies to Table	This read-only field displays the data table to which the calculated field applies. When you create a new calculated field, you select the table to which it applies on the New Calculated Field dialog box. You cannot edit this field for an existing or copied calculated field.
Calculate Summary Rows Horizontally	Select this option if you want to summarize the calculated fields. Open Plan first calculates the summary value of the fields used in the expression, and then evaluates the expression for the Summary row. For example, using the expression IIF(ASDATE = {}, 0, 1), Open Plan summarizes ASDATE, which results in the earliest ASDATE found among the rows that are summarized. Open Plan takes the "summarized" date and evaluates the calculated field expression one time. Since the summary date is non-blank, you will get a value of 1 in the Summary row (this will always be the case, no matter how many rows in the Summary heading have non-blank values, as long as there is at least one non-blank value). When you do not select this option (default), a single summary value is calculated. Open Plan evaluates the expression in each row that is part of the summary and summarizes the individual values. For example, using the expression IIF(ASDATE = {}, 0,1), results in a value of 0 for any row where ASDATE is blank and 1 for any row where ASDATE is non-blank. If there are two rows with non-blank ASDATEs under the Summary heading, Open Plan displays a value of 2 in the Summary row. The Summary row value increases by one each time you change an ASDATE from blank to non-blank.
Data Type	Use this field to select the type of data you want the calculated field to return. Date: Select to return a date to the calculated field. Decimal: Select to return a decimal number, for example, 7.89 to the calculated field. Duration: Select to return a duration to the calculated field. Finish Date: Select to return an activity finish date to the calculated field. Integer: Select to return a whole number to the calculated field. Character: Select to return a character string to the calculated field. Logical: Select to return a True or False value to the calculated field.
No. of Decimal Places	Use this field to enter the level of precision you want in the calculation. This field is only available when you select Decimal in the Data Type field.
OK	Click to apply the criteria you set for the calculated field.
Cancel	Click to close the dialog box without making any changes to the calculated field.
Fields...	Click to display the Fields dialog box where you can select a field to include in the calculated field expression.
Functions...	Click to display the Functions dialog box where you can select a function to include in the calculated field expression.
Access Control	Click to display the Access Control dialog box where the owner of the calculated field can define the groups and users who can have access to the calculated field.
References	Click to display the References dialog box where you can view the files that use the calculated field.
Help	Click to display the dialog box help topic.
Resizing	Drag any corner of the dialog box to resize it according to your preference.

JavaScript must be enabled in order to use this site.Please enable JavaScript in your browser and refresh the page.

Contents of the Calculated Field Expression Dialog Box

Use this fields and options to configure the Calculated Field Expression dialog box.

Contents

Field	Description
Name	When you are creating a copy of an existing calculated field, use this field to enter a new name for the copy. When you are modifying an existing calculated field, this field is disabled.
Expression	This box displays the expression that defines the calculated field or global edit you selected in the [Results] field on the Calculated Fields dialog box. The expression can include the following elements: Character operators Constants Duration operators Field names Functions Logical operators Mathematical operators Calculated fields Relational operators When you modify the criteria of a calculated field, the expression also changes. You can use this box to enter additional expression elements manually. For more information, see Expression Elements. Note: When Open Plan displays an error, the portion of the failed expression is highlighted.
Applies to Table	This read-only field displays the data table to which the calculated field applies. When you create a new calculated field, you select the table to which it applies on the New Calculated Field dialog box. You cannot edit this field for an existing or copied calculated field.
Calculate Summary Rows Horizontally	Select this option if you want to summarize the calculated fields. Open Plan first calculates the summary value of the fields used in the expression, and then evaluates the expression for the Summary row. For example, using the expression IIF(ASDATE = {}, 0, 1), Open Plan summarizes ASDATE, which results in the earliest ASDATE found among the rows that are summarized. Open Plan takes the "summarized" date and evaluates the calculated field expression one time. Since the summary date is non-blank, you will get a value of 1 in the Summary row (this will always be the case, no matter how many rows in the Summary heading have non-blank values, as long as there is at least one non-blank value). When you do not select this option (default), a single summary value is calculated. Open Plan evaluates the expression in each row that is part of the summary and summarizes the individual values. For example, using the expression IIF(ASDATE = {}, 0,1), results in a value of 0 for any row where ASDATE is blank and 1 for any row where ASDATE is non-blank. If there are two rows with non-blank ASDATEs under the Summary heading, Open Plan displays a value of 2 in the Summary row. The Summary row value increases by one each time you change an ASDATE from blank to non-blank.
Data Type	Use this field to select the type of data you want the calculated field to return. Date: Select to return a date to the calculated field. Decimal: Select to return a decimal number, for example, 7.89 to the calculated field. Duration: Select to return a duration to the calculated field. Finish Date: Select to return an activity finish date to the calculated field. Integer: Select to return a whole number to the calculated field. Character: Select to return a character string to the calculated field. Logical: Select to return a True or False value to the calculated field.
No. of Decimal Places	Use this field to enter the level of precision you want in the calculation. This field is only available when you select Decimal in the Data Type field.
OK	Click to apply the criteria you set for the calculated field.
Cancel	Click to close the dialog box without making any changes to the calculated field.
Fields...	Click to display the Fields dialog box where you can select a field to include in the calculated field expression.
Functions...	Click to display the Functions dialog box where you can select a function to include in the calculated field expression.
Access Control	Click to display the Access Control dialog box where the owner of the calculated field can define the groups and users who can have access to the calculated field.
References	Click to display the References dialog box where you can view the files that use the calculated field.
Help	Click to display the dialog box help topic.
Resizing	Drag any corner of the dialog box to resize it according to your preference.