Adding a computed field to a list

A compute field is a field that calculates other fields. You can use the Add Compute... button to calculate numeric data and dates from fields on the list or form you are working with.

  1. Go to the list editor view. From the toolbar of the list that you want to personalize, click Options > Personalize.
  2. On the Column tab, click Add Compute...

    The List Compute Editor screen displays.

  3. Type a label for the field. The first letter must be upper-case.
  4. Select the type of totaling.

    • None

    • Total: The total of all records

    • Running Total: The total at the current point in the records

    • Percent of Total: The percent of the total that this set of records represents

  5. Create the expression to calculate.

    The expression builder provides some help for creating a logical calculation but you must be knowledgeable about the type of data in the fields in order to be sure that the new field provides the data you are attempting to calculate.

    1. Select the fields you want to calculate. Double-click a field to add it to the Computed Field text box.

      You can use filtering options One to Many and Keywords to narrow the list of fields.

    2. Select the type of field: Date, Field, One to Many.

      Depending on the type of field, options for the calculation (date format, weight, so on) are available. Make the appropriate selections for your calculation.

    3. Select an operator (+, -, *, and so on) after each field selection to make the comparison or calculation.
  6. Click OK when you are finished selecting options for your new calculated field.