Progress
Report Builder
User’s Guide


Aggregate Field Considerations

When you create an aggregate field, you must consider how Report Builder handles UNKNOWN values. Report Builder makes the value of an aggregate field UNKNOWN if any of the aggregated values is UNKNOWN unless you specify to ignore UNKNOWN or blank values. The exception to this rule is a COUNT aggregate. Because a COUNT aggregate just counts records without regard for the field value, a COUNT aggregate treats UNKNOWN the same as any other value. For all other types of aggregates, if one or more of the records has an UNKNOWN value in the aggregate field, the whole aggregate becomes UNKNOWN, unless you specify otherwise.

Report Builder also displays an UNKNOWN value if:

See "Fields," for a complete description of how Report Builder handles UNKNOWN values, including how Report Builder processes UNKNOWN values in different types of operations.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095