Applying Summaries

  • 2 minutes to read

End-users can manipulate summaries using context menus. These menus can be invoked by right-clicking a footer cell. Each menu item corresponds to a summary type (sum, average, etc). Clicking an item applies the appropriate summary to the column whose footer cell was clicked. Each summary type applied has a default display format. The table below lists menu items, their corresponding summary types and default format strings.

Menu Item Effect
Sum The summary value is the sum of column values. The default format string is "SUM={0:#.##}".
Min The summary value is the column's minimum value. The default format string is "MIN={0}".
Max The summary value is the column's maximum value. The default format string is "MAX={0}".
Count The summary value is the number of records within the calculation range. The default format string is "{0}".
Average The summary value is the column's average value. The default format string is "AVR={0:#.##}".
None Cancels summary calculation.

Notes:

See Also