Adding a computed field to a list

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

  1. From the list to personalize, select More Actions > Options > Personalize.
  2. Select Create or Update.
  3. On the Column tab, click Add (+) and select Add Compute.
  4. Specify this information:
    Label
    Specify the column name to show on the list. Ensure the first letter is in uppercase.
    Compute
    Specify the expression to calculate. The expression builder is used to create logical calculations, but you must know the data types in the fields to ensure the new field returns the results you intend to calculate.

    • Specify the fields to calculate.

    • Specify an operator, such as +, -, or * after each field to make the comparison or calculation.

    Decimal Size

    Specify the number of decimal places displayed for computed fields in a list.

    Totaling
    Select the type of totaling with any of these options:

    • 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. Click OK.