CrosstabAvgDec
DataWindow expression function
Description
Calculates the average of the values returned by an expression in
the values list of the crosstab and returns a result with the decimal
datatype. When the crosstab definition has more than one column,
CrosstabAvgDec can also calculate averages of the expression’s values for
groups of column values.
For crosstabs only
You can use this function only in a crosstab DataWindow
object.
Syntax
|
1 |
CrosstabAvgDec ( n {, column, groupvalue } ) |
|
Argument |
Description |
|---|---|
|
n |
The number of the crosstab-values expression for |
|
column (optional) |
The number of the crosstab column as it is listed in |
|
groupvalue (optional) |
A string whose value controls the grouping for the |
Return value
Decimal. Returns the average of the crosstab values returned by
expression n for all the column values or, optionally, for a subset of
column values.
Usage
Use this function instead of CrosstabAvg when you want to return a
decimal datatype instead of a double datatype. For more information, see
CrosstabAvg.
See also