Defining summary fields
Use summary fields to calculate values such as subtotals, averages, and grand totals across multiple records. For example, a summary field can display the grand total of all sales in the month of May in a report.
To define summary fields:
1.
With the database open, choose File menu > Manage > Database.
2.
3.
4.
For Field Name, type a name for the field.
See About naming fields.
5.
For Type, select Summary.
6.
Click Create.
7.
 
8.
 
Show the cumulative total for the current and all previous records. To restart the running total for each sorted group, also select Restart summary for each sorted group and select the field upon which the sort will be restarted from the field list.
Weighted average. In the field list that appears, select the field that contains the weight factor.
Show the cumulative count of the current and all previous records. To restart the running count for each sorted group, also select Restart summary for each sorted group and select the field upon which the sort will be restarted from the field list.
Subtotaled. In the field list that appears, select the field to group by.
9.
If the field you are summarizing is a repeating field, you have the option to summarize the repetitions together or individually.
Select All together to calculate a single summary value for all repetitions in the field.
Select Individually to calculate a summary value for each repetition.
Note  You must format your summary field as a repeating field to display individual summary values. See Setting up the display of repeating fields.
10.
Click OK, then continue defining fields or click OK.
To define summary fields in Table View:
1.
2.
Click + in the column heading to add a new field.
3.
Right-click the column heading for the new field, then choose Field > Field Type > Summary from the shortcut menu.
4.
Notes
 •
 •
 •
 •
If you choose Fraction of Total of, you can specify a group field for Subtotaled. When you return to Browse mode, you must sort by the group field to calculate the value correctly.
 •
The standard deviation formula is n-1 weighted, following the normal standard deviation.
 •
 •
 •
Related topics 
Changing summary fields
Summary data is missing or incorrect
Specifying formats for fields containing numbers