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 |
<span>CrosstabCount</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
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 |
<span>CrosstabCount</span>(1) |
This expression for a computed field in the crosstab
returns the count of the salary totals (the second expression):
|
1 |
<span>CrosstabCount</span>(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 |
<span>CrosstabCount</span>(1, 2, "@year") |
This expression for a computed field returns the
count of all the sales in the row:
|
1 |
<span>CrosstabCount</span>(1) |
For an example illustrating how the painter automatically
defines a crosstab by creating computed fields using the Crosstab
functions, see CrosstabAvg.