Use the Modify Total Function dialog box to change the standard mathematical functions for totals in the Results Section.
For example, you could total yearly amounts three to four times and apply different functions to each of the totals. In this way, your Results section could contrast values such as sums, averages, or maximum values with other standard or customized mathematical functions that you specify.
To modify a total function, select a function from the Grand Total Function drop-down list box and click OK.
You can select any of the following functions:
Table 30. Grand Total Functions (Continued)
Option | Description |
|---|---|
Sum | Returns the total of a column of numbers. |
Average | Returns the average (arithmetic mean) of values in a number column. (The Avg includes NULL values when calculating the arithmetic mean.) |
Maximum | Returns the largest of items in a column. |
Minimum | Returns the smallest of items in a column. |
Count | Counts and returns the number of rows in a column. |
Other | Applies a custom function. |