APPLICATION DESIGN

Generating column totals, averages, and percents
To display totals, averages, or percents for a column's numeric values, click the Sorting tab of the Column Properties box and select a Totals type other than None. Totals display in blue, unless you change the Column Totals color on the Style tab of the View Properties box.

Totals calculate only for main documents; response documents are not included. Because column totals recalculate each time you open the view, they may affect database and overall server performance.

Total calculates a grand total for all main documents and displays this total at the bottom.

Average per document calculates an overall average by totaling the values of the main documents and then dividing that value by the number of main documents. For example, if there are four documents and their total is 10, the average per document is 2.5.

Average per subcategory calculates an average for each category. Within each subcategory, the documents are summed; that value is divided by the number of documents.

Percent of parent category calculates a total for all main documents. For each category, IBMR LotusR NotesR displays the category's percentage as it relates to the overall view total.

Percent of all documents calculates a total for all documents. For each category, Notes displays the category's percentage as it relates to the overall view total.

To display totals without the clutter of extra numbers, select "Hide detail rows" to suppress numbers other than totals or subtotals for each category and subcategory.

See Also