Count  CrosstabCount

Chapter 2: DataWindow Expression Functions

CrosstabAvg

Description

Calculates the average of the values returned by an expression in the values list of the crosstab. When the crosstab definition has more than one column, CrosstabAvg can also calculate averages of the expression’s values for groups of column values.

NotePocketBuilder This function is not available for DataWindow objects that you use in PocketBuilder. You can use this function in a crosstab DataWindow object or report only.

Syntax

CrosstabAvg ( n {, column, groupvalue } )

Returns

Double. Returns the average of the crosstab values returned by expression n for all the column values or, optionally, for a subset of column values.





Copyright © 2004. Sybase Inc. All rights reserved. CrosstabCount

View this book as PDF