Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 665
Usage Use this function instead of CrosstabMin when you want to return a decimal
datatype instead of a double datatype. For more information, see
CrosstabMin.
See also CrosstabAvgDec
CrosstabMaxDec
CrosstabSumDec
CrosstabSum
Description Calculates the sum of the values returned by an expression in the values list of
the crosstab. When the crosstab definition has more than one column,
CrosstabSum 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 report.
Syntax CrosstabSum ( n {, column, groupvalue } )
Return value
Double. Returns the total of the values returned by expression n for all the
column values or, optionally, for a subset of column values. To return a decimal
datatype, use
CrosstabSumDec.
Usage This function is meaningful only for the sum of the values of the expression in
a row in the crosstab. This means you can use it only in the detail band, not in
a header, trailer, or summary band.
Null values are ignored and are not included in the sum.
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.