Add a Formula-based Activity Configured Field: Example

This example demonstrates how to create an activity configured field to calculate and display the activity count.

Note For information on creating advanced formulas to set values for configured fields and measures, refer to the Oracle Primavera Cloud Expression Language Guide on Oracle Help Center.

Let us assume that you are a former P6 user who recently migrated to Primavera Cloud, and you want to display the current schedule's activity count as a column header on the Activities page. Since this field does not exist in Primavera Cloud, you decide to create it manually using a formula-based configured field to perform the calculation by following the steps below.

Creating a Configured Field

  1. In the object selector, select Workspace.
  2. In the object selector, beside a workspace name, select , and then select View Summary & Settings.
  3. On the Activity page, select Configured Fields.
  4. Select +Add.
  5. In the table, complete the following fields:
    1. In the Column Label column, enter Activity Count.
    2. In the View Column Name column, enter ACTIVITY_COUNT.
    3. In the Data Type column, select Number.
    4. In the Type column, select Formula.
    5. In the Summary Calculation column, select Sum.

Defining a Formula

  1. In the Formula detail window, in the Field list, select Approved Budget, and select Insert Field.
  2. Select +.
  3. In the Field list,in the General section, select Activity Name, and then select Insert Field.
  4. Select + and type 1.

    Each activity is counted as 1 in the calculation.

  5. Select Validate Formula.
  6. In the Formula validation passed dialog box, select OK.
  7. Select Save.
  8. Configure the new column in the Manage Views panel. See Configure a Column.

Tip

  • To delete a configured field, select the field, select "" Context, and then select Delete. You cannot delete a configured field if it is used in another configured field, a form, a workflow, or a field mapping.
  • Primavera Cloud calculates formula-configured fields asynchronously, so values might take longer to update than other fields.

Last Published Monday, April 13, 2026