Using crosstab functions
There are nine special functions you can use only in crosstabs: CrosstabAvg, CrosstabAvgDec, CrosstabCount, CrosstabMax, CrosstabMaxDec, CrosstabMin, CrosstabMinDec, CrosstabSum,
and CrosstabSumDec.
These functions are listed in the Functions box when you define
a computed field in a crosstab:
Each of these functions returns the corresponding statistic
about a row in the crosstab (average, count, maximum value, minimum
value, or sum). You place computed fields using these functions
in the detail band in the Design view. Use the functions with the Dec suffix
when you want to return a decimal datatype.
By default, PowerBuilder places CrosstabSum and
CrosstabSumDec in the detail band, which returns the total for the
corresponding row.
How to specify the functions
Each of these functions takes one numeric argument, which
refers to the expression defined for Values in the Crosstab Definition
dialog box. The first expression for Values is numbered 1, the second
is numbered 2, and so on.
Generally, crosstabs have only one expression for Values,
so the argument for the crosstab functions is 1. So, for example,
if you defined sum(units for crosstab) as
your Values expression, PowerBuilder places CrosstabSum(1) in
the detail band.
If you want to cross-tabulate both total unit sales and a
projection of future sales, assuming a 20 percent increase in sales
(that is, sales that are 1.2 times the actual sales), you define
two expressions for Values:
|
1 |
sum(units for crosstab)<br>sum(units * 1.2 for crosstab) |
Here CrosstabSum(1) returns
the total of sum(units for crosstab) for the
corresponding row. CrosstabSum(2) returns
the total for sum(units * 1.2 for crosstab).
For more information
For complete information about defining computed
fields, see Chapter 19, “Enhancing DataWindow Objects .”
For more about the crosstab functions, see the DataWindow Reference.