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

Function Libraries Group on the Metrics Tab

The Acumen metric editor supports all MS Excel functions. Use the ribbon commands to select MS Excel formulas.

The most commonly used formulas are grouped in the Common function library. Other function libraries include:

  • Financial
  • Logical
  • Text
  • Date & Time
  • Lookup & Reference
  • Math & Trig
  • Statistical
  • Information

Acumen Functions

The Acumen functions library includes the following functions:

  • FISCALPERIODNUM: Use this function to return the corresponding fiscal period number for a given DateTime. The function includes two parameters:
    • Any date field on the object
    • The Project field

    For example: FISCALPERIODNUM(Start, Project)

  • SNAP: Use this function to add snapshot values to metric formulas to access field values from prior or subsequent periods. To do this, you add Snap(+/-x).<field> to the metric formula where + or - equals forward or back from the current selection, x equals the number of periods forward or back, and <field> equals a valid field.

    For example, Snap(+1).ActualStart, means that you want the Actual Start field value from the snapshot one later than the current selection. Snap(-2).ActualStart means that you want the Actual Start field value from the snapshot two versions past.

    An example of a metric formula could be:

    SUM( IF( (ISNUMBER(Snap(-1).ActualStart)) * ( Snap(-1).ActualStart<> ActualStart) ,1,0) )

    You can use the snap function in activity, work package, control account, and calculated field metric formulas.