CrosstabSumDec DataWindow expression function
Description
Calculates the sum 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, CrosstabSumDec can also calculate the sum
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 |
<span>CrosstabSumDec</span> ( <span>n</span> {, <span>column</span>, <span>groupvalue</span> } ) |
|
Argument |
Description |
|---|---|
|
n |
The number of the crosstab-values expression |
|
column (optional) |
The number of the crosstab column as |
|
groupvalue (optional) |
A string whose value controls the grouping |
Return Values
Decimal. Returns the total of the values returned by expression n for
all the column values or, optionally, for a subset of column values.
Usage
Use this function instead of CrosstabSum when
you want to return a decimal datatype instead of a double datatype.
For more information, see CrosstabSum.