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
CrosstabSumDec ( n {, column, groupvalue } )
|
Argument |
Description |
|---|---|
|
n |
The number of the crosstab-values expression for which you want the sum of the returned values. The expression's datatype must be numeric. |
|
column (optional) |
The number of the crosstab column as it is listed in the Columns box of the Crosstab Definition dialog box for which you want intermediate calculations. |
|
groupvalue (optional) |
A string whose value controls the grouping for the calculation. Groupvalue is usually a value from another column in the crosstab. To specify the current column value in a dynamic crosstab, rather than a specific value, specify @ plus the column name as a quoted string. |
Return value
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.
See also
