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.
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. |
Decimal. Returns the total of the values returned by expression n for all the column values or, optionally, for a subset of column values.
Use this function instead of CrosstabSum when you want to return a decimal datatype instead of a double datatype. For more information, see CrosstabSum.
