Specifications

Var
756 InfoMaker
Return value Double or decimal if the arguments are decimal. Returns an estimate for the
variance for column. If you specify group,
Var returns an estimate for the
variance for column within group.
Usage If you specify range, Var returns an estimate for the variance for column within
range. If you specify DISTINCT,
Var returns the variance for the distinct
values in column, or if you specify expresn, the estimate for the variance of the
rows in column where the value of expresn is distinct.
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.
FOR range
(optional)
The data to be included in the estimate of the variance. For most
presentation styles, values for range are:
• ALL – (Default) The estimate of the variance for all rows in
column.
• GROUP n – The estimate of the variance for rows in column in
the specified group. Specify the keyword GROUP followed by
the group number: for example, GROUP 1.
• PAGE – The estimate of the variance for the rows in column on
a page.
For Crosstabs, specify CROSSTAB for range:
• CROSSTAB – (Crosstabs only) The estimate of the variance for
all rows in column in the crosstab.
For Graph and OLE objects, specify one of the following:
• GRAPH – (Graphs only) The estimate of the variance for rows
in column in the range specified for the Rows option.
• OBJECT – (OLE objects only) The estimate of the variance for
rows in column in the range specified for the Rows option.
DISTINCT
(optional)
Causes
Var to consider only the distinct values in column when
determining the variance. For a value of column, the first row found
with the value is used and other rows that have the same value are
ignored.
expresn
(optional)
One or more expressions that you want to evaluate to determine
distinct rows. Expresn can be the name of a column, a function, or
an expression.
Argument Description