Progress
Report Builder
User’s Guide
Included Values
You can specify what types of values you want the aggregate field to include or ignore. The default value is to include all values, including UNKNOWN, blank, and zero values.
You can specify to ignore two types of values:
- UNKNOWN values — Instructs Report Builder to ignore all UNKNOWN values when computing the aggregate. This means that Report Builder will not return UNKNOWN simply because one record contains an UNKNOWN value in the field being aggregated.
- Blanks or zeros (0) — Instructs Report Builder to omit zeros (for numeric fields) or blanks (for character fields) when computing the aggregate. This option is useful for omitting blank or zero values from Average or Minimum aggregates or for producing a Count of only nonblank, nonzero, or KNOWN records.
See the "Aggregate Field Considerations" section for a description of aggregate fields and UNKNOWN values.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |