Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions

Users Guide 653

Not in validation rules or filter expressions

You cannot use this or other aggregate functions in validation rules or filter

expressions.

Using an aggregate function cancels the effect of setting Retrieve Rows As

Needed in the painter. To do the aggregation, a report always retrieves all rows.

Examples This expression returns the number of rows in the column named emp_id that

are not null:

Count(emp_id)

This expression returns the number of rows in the column named emp_id of

group 1 that are not null:

Count(emp_id for group 1)

This expression returns the number of dept_ids that are distinct:

Count(dept_id for all DISTINCT)

This expression returns the number of regions with distinct products:

Count(region_id for all DISTINCT Lower(product_id))

This expression returns the number of rows in column 3 on the page that are

not null:

Count(#3 for page)