Specifications

StDevP
744 InfoMaker
This expression for a computed field in a crosstab returns the estimate for
standard deviation of the values in the qty_ordered column in the crosstab:
StDev(qty_ordered for crosstab)
Assuming a report displays the order number, amount, and line items for each
order, this computed field returns the estimated standard deviation of the order
amount for the distinct order numbers:
StDev(order_amt for all DISTINCT order_nbr)
See also StDevP
Var
StDevP
Description Calculates the standard deviation for the specified column. Standard deviation
is a measurement of how widely values vary from average.
Syntax StDevP ( column { FOR range { DISTINCT { expres1 {, expres2 {, ... } } } } } )
Argument Description
column The column for which you want the standard deviation 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 to be included in the standard deviation. For most
presentation styles, values for range are:
• ALL – (Default) The standard deviation for all values in column.
• GROUP n – The standard deviation for values in column in the
specified group. Specify the keyword GROUP followed by the
group number: for example, GROUP 1.
• PAGE – The standard deviation for the values in column on a
page.
For Crosstabs, specify CROSSTAB for range to indicate the
standard deviation for all values in column in the crosstab.
For Graph objects specify GRAPH and for OLE objects specify
OBJECT to indicate the standard deviation for values in column in
the range specified for the Rows option.