Deltek Open Plan 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

Expression Elements

Expression elements are expressions defining a calculated field or a global edit.

Element Description
Character operators You can include the following character operators in a calculated field or global edit expression:
  • Concatenate (+)
    Sample Usage Result
    "Quick" + "Brown Fox" "Quick Brown Fox"
  • Contained in ($)
    Sample Usage Result
    "ABC" $ "123ABCDEF" TRUE
Constants You can include text, date, numeric, and logical constants in a calculated field or global edit:
  • All text must be enclosed in either single or double quotes.
  • Dates must be enclosed in curly brackets ({ and }).
  • Durations must be enclosed between piping symbols ( | ).
  • Numeric constants can include any positive or negative value and can appear with or without decimal places.
  • Valid logical constants are [True] and [False].
  • Values for enumerated fields (that is, fields with a limited number of valid values) must be enclosed between square brackets ([ and ]). To see a list of the fields that are enumerated in Open Plan, see Fields in Open Plan.
Duration operators You can include the following duration operators in a calculated field or global edit expression:
Operator Expression Result
Add (+) Duration + Duration Duration
Date + Duration Date
Subtract (-) Duration - Duration Duration
Date - Duration Date
Divide (/) Duration / Duration Decimal
Duration / Number Duration
Multiply (*) Duration * Number Duration
Field names When including a field in an expression for a calculated field or global edit, you must enter the name of the field and not the descriptive name that is displayed in spreadsheet column headings. For example, if you want to define a calculated field expression that references the field containing early start dates, you must identify the field as ESDATE, not Early Start.
Functions Calculated field and global edit expressions can contain a number of functions. For more information, refer to the topic "Using the Functions Dialog Box" accessed by clicking See Also on this Help topic.
Logical operators You can include the following logical operators in a calculated field or global edit expression: AND; NOT; OR; AND NOT; Group (( ))
Mathematical operators You can include the following mathematical operators in a calculated field or global edit expression: Add (+); Subtract (-);Multiply (*);Divide (/);Group (( )); Exponentiate (^ or **).

Expressions containing mathematical operators are evaluated according to the normal rules of precedence:

  • Grouping operations are performed before multiplication and division operations.
  • Multiplication and division operations are performed before addition and subtraction operations.
Calculated fields Expressions defining calculated fields or global edits can include references to previously defined calculated fields. Note that a calculated field cannot include a reference to itself.
Relational operators Expressions for calculated fields or global edits can include the following relational operators: Equal to (=);Not equal to (<>);Greater than (>);Greater than or equal to (>=);Less than (<);Less than or equal to (<=);Contained in ($)