Specifications

VarP
758 InfoMaker
Assuming a report displays the order number, amount, and line items for each
order, this computed field returns the estimate for the variance of the order
amount for the distinct order numbers:
Var(order_amt for all DISTINCT order_nbr)
See also
StDev
Var P
VarP
Description Calculates the variance for the specified column. The variance is the square of
the standard deviation.
Syntax VarP ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } )
Argument Description
column The column for which you want the variance of the values in the
rows. 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 variance. For most presentation
styles, values for range are:
• ALL – (Default) The variance for all rows in column.
• GROUP n – 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 variance for the rows in column on a page.
For Crosstabs, specify CROSSTAB for range:
• CROSSTAB – (Crosstabs only) The variance for all rows in
column in the crosstab.
For Graph and OLE objects, specify one of the following:
• GRAPH – (Graphs only) The variance for rows in column in the
range specified for the Rows option.
• OBJECT – (OLE objects only) The variance for rows in column
in the range specified for the Rows option.
DISTINCT
(optional)
Causes
VarP 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.