CrosstabCount
DataWindow expression function
Description
Counts the number of values returned by an expression in the values
list of the crosstab. When the crosstab definition has more than one
column, CrosstabCount can also count the number 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 |
CrosstabCount ( 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
Long. Returns the number of values returned by expression n for all
the column values or, optionally, for a subset of column values.
Usage
This function is meaningful only for the count 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 count.
For more information about restricting the calculation to groups of
values when the crosstab definition has more than one column, see Usage
for CrosstabAvg.
Reviewing the expressions
To review the expressions defined for the crosstab values, open
the Crosstab Definition dialog box (select Design>Crosstab from the
menubar).
Examples
These examples all use the crosstab-values expressions shown
below:
|
1 |
Count(emp_id for crosstab), Sum(salary for crosstab) |
This expression for a computed field in the crosstab returns the
count of the employee counts (the first expression):
|
1 |
CrosstabCount(1) |
This expression for a computed field in the crosstab returns the
count of the salary totals (the second expression):
|
1 |
CrosstabCount(2) |
The next two examples use a crosstab with two columns (year and
quarter), a row (product), and the values expression Avg(sales for
crosstab).
This expression for a computed field returns the count of the sales
for each year:
|
1 |
CrosstabCount(1, 2, "@year") |
This expression for a computed field returns the count of all the
sales in the row:
|
1 |
CrosstabCount(1) |
For an example illustrating how the painter automatically defines a
crosstab by creating computed fields using the Crosstab functions, see
CrosstabAvg.
See also