Crosstab.Cells.Avg

combit List & Label Designer

combit List & Label

Crosstab.Cells.Avg

Purpose:

Returns the average of the cell contents. Only available in crosstab objects.

Parameter:

Boolean       (optional) True: Only defined values are entered into the calculation (Default: False). Defined values: if you are, for example, analyzing customers and quarters, the quarters without turnover constitute an undefined value and can be treated separately in the calculation.

Number         (optional) Row layer (0= bottom layer or innermost group, 1= next lowest, ...). Default: 0.

Number         (optional) Column layer (0= bottom layer or innermost group, 1= next lowest, ...). Default: 0.

Return value:

Number