Configure list calculations

You can configure list calculations for columns, which calculate column totals, minimums, maximums, and averages.

Before you begin

Role required: personalize_list

About this task

You can configure list calculations for multiple columns in the same list. List calculations apply only to the view of the list in which they are configured. All users can see configured list calculations.

Note: List calculations are available in list reports.

Procedure

  1. In a list of records, right-click the header of a numeric column you want to evaluate with list calculations.
  2. Select Configure > List Calculations.
    A dialog box appears.
    List calculation options
  3. Select one or more of the following list calculation options:
    • Total value (not available for string, date, or date/time fields)
    • Minimum value
    • Maximum value
    • Average value (not available for string, date, or date/time fields)
  4. Click OK.
    The calculations appear below the last record in the column. If the list is grouped, in addition to the overall calculations at the bottom of the list, group calculations appear below the last record in each group.