Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions

Users Guide 669

Settings for Rows include the following:

• For the Graph presentation style, Rows is always All.

• For Graph controls, Rows can be All, Page, or Group.

• For OLE controls, Rows can be All, Current Row, Page, or Group. The

available choices depend on the layer the control occupies.

In calculating the percentage, null values are ignored.

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 running percentage for the values that are not null

in the column named salary:

CumulativePercent(salary)

This expression returns the running percentage for the column named salary for

the values in group 1 that are not null:

CumulativePercent(salary for group 1)

This expression entered in the Value box on the Data property page for a graph

returns the running percentage for the salary column for the values in the graph

that are not null:

CumulativePercent(salary for graph)

This expression in a crosstab computed field returns the running percentage for

the salary column for the values in the crosstab that are not null:

CumulativePercent(salary for crosstab)