1 / 6

Effective Use of Summary Functions in Data Reports

This guide details the use of the SUMMARIZE BY command in data reporting, which allows for control breaks based on changes in sort field values. Key functionalities include performing summary calculations like subtotals, counts, averages, minimums, and maximums at specified break points. Users can define sort fields in any order and request a grand summary using a '0'. Examples of suffixes for summary functions are provided, enabling users to combine multiple functions for enhanced reporting.

caldwell-humphrey
Télécharger la présentation

Effective Use of Summary Functions in Data Reports

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Summarize By: January 8, 2003 Train the Trainer Cary Bidot, South Puget Sound

  2. Summarize By: • The SUMMARIZE BY prompt calls for the numbers of the sort fields you want to use as control breaks. • A break point occurs when a sort field value changes and is a place where you may want to perform functions (eg: subtotal, count, average, minimum, maximum) on certain fields. • The sort field numbers can be entered in any order, separated by commas, and you may include a '0' (zero) to indicate that a grand (total report) summary line is also required.

  3. Type of Summary Functions: The field number may be followed by a suffix indicating the type of summary function: • '*' for subtotal (default if no suffix) • 'C' for count • 'A' for average • 'L' for low (minimum) • 'H' for high (maximum) • 'E' for last value (ending). A field can have more than one summary function specified, for example: '3,4,4C,1L,5A,1H'.

  4. Break Point

  5. Summary Functions

  6. Finished Report Summary Functions Break Point

More Related