Deltek Acumen 8.8 Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Calculated Fields on the Metrics Tab

Calculated fields allow you to evaluate a standard part of a formula for reuse in metrics, either at the same level at which they are defined (activity, work package, control account), or to roll values up or down from one level to another.

You can use a calculated field to develop an activity metric to see data in the activity, control account, or WAD, or create a control account metric that sees, for example, the earliest baseline start of an activity.

You can select a calculated field on the Define Columns tab to display as a column in the Activity Browser grid on the S2 // Diagnostics tab. You can also select them on the Detailed Report tab to display on the Fuse Detailed Metric report.

When you are designing a metric, you start by creating a calculated field to pull the data and then use the calculated field in a metric.

Calculated fields are available for use in the Filter and Formula sections of the metrics.

The Acumen installation includes several default activity, work package, and control account calculated fields (when using the DECM metric template). In order to use calculated fields, you must have imported the project cost data because that establishes control accounts and work packages.

The Functions menu group includes a few of the more common functions; however, you can use many other functions in a calculated field or formula.

Example of Creating a Calculated Field

Using the formula below, you can view the earliest baseline start from activities. The BaselineStart field could exist in more than one place (activity, work package, control account, WAD); however, ACT shows you that it is from the activity. This is further confirmed by the Operates On field being set to Activities which means that there should only be activity fields in the formula.

Example of Adding a Calculated Field to a Metric Formula

Use the Metrics tab Calculated Fields form to create a calculated field called ActivityRemCost and add it to the metric formula on one of the Metric forms.

The calculated field is created:

The calculated field is added to the metric: