Specifications

CumulativePercent
668 InfoMaker
CumulativePercent
Description Calculates the total value of the rows up to and including the current row in the
specified column as a percentage of the total value of the column (a running
percentage).
Syntax CumulativePercent ( column { FOR range } )
Return value
Long. Returns the cumulative percentage value.
Usage If you specify range, CumulativePercent restarts the accumulation at the start
of the range.
For graphs and OLE objects, you do not select the range when you call the
function. The range has already been determined by the Rows setting on the
Data property page (the Range property), and the aggregation function uses
that range.
Argument Description
column The column for which you want the cumulative value of the rows
up to and including the current row as a percentage of the total value
of the column for range. Column can be the column name or the
column number preceded by a pound sign (#). Column can also be
an expression that includes a reference to the column. The datatype
of column must be numeric.
FOR range
(optional)
The data that will be included in the cumulative percentage. For
most presentation styles, values for range are:
• ALL – (Default) The cumulative percentage of all rows in
column.
• GROUP n – The cumulative percentage of rows in column in the
specified group. Specify the keyword GROUP followed by the
group number: for example, GROUP 1.
• PAGE – The cumulative percentage of the rows in column on a
page.
For Crosstabs, specify CROSSTAB for range:
• CROSSTAB – (Crosstabs only) The cumulative percentage of
all rows in column in the crosstab.
For Graph and OLE objects, specify one of the following:
• GRAPH – (Graphs only) The cumulative percentage of values in
column in the range specified for the Rows option.
• OBJECT – (OLE objects only) The cumulative percentage of
values in column in the range specified for the Rows option.