Deltek Acumen 8.5 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

COUNTIF

This counts the number of occurrences that meet a given criteria.

COUNTIF(range, criteria)

  • Range (Required) is one or more fields that contain numbers.
  • Criteria (Required) is a number, expression, or text string that defines which records to be counted. For example, criteria can be expressed as 3, ">3","Normal", or "3".

Example: COUNTIF(TotalFloat,">5") counts the number of activities who have a Total Float value greater than 5.