Defining Formulas for User Defined Fields

Define formulas to calculate values for the user defined field. You can create formulas for project user defined fields.

To define formulas for user defined fields:

1. On the Navigation Menu, expand Administration and click Enterprise Data.
2. On the Enterprise Data page, expand Projects and click Project UDFs.
3. On the Project UDFs page, select a UDF with the UDF Type of Formula and click the Formula detail window.
4. In the Formula detail window:
   1. Click the Fields list and choose a field.

      Note:

      You can select any existing project-related field defined in the project management database, including project codes, or any other user defined field that exists for your organization.

   2. Click Insert Field.
   3. Continue to build your formula by inserting fields and using the operator buttons.

      Note:

      If your formula contains a date, any numeric values used with the date in the formula are hours. For example, the result of the formula [Data Date]+20 is the data date plus twenty hours.

5. Click Save.

Tip:

If a Project UDF cannot be calculated, for example because the data used in the formula is unavailable, the column on the EPS page displays Locked.