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:
- Click Administration.
- On the Administration navigation bar, click Enterprise Data.
- On the Enterprise Data page, expand Projects and click Project UDFs.
- On the Project UDFs page, select a UDF with the UDF Type of Formula and click the Formula detail window.
- In the Formula detail window:
- 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.
- Click Insert Field.
- 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.
- Click the Fields list and choose a field.
- Click Save.
Tips
- 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.
Related Topics
Defining Indicators for User Defined Fields
Defining Statements for User Defined Fields
Last Published Tuesday, March 26, 2024