Crosstab.Cells.Avg

 

Purpose:

Returns the mean value 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 level (0= bottom level or innermost group, 1= next lowest, ...). Using -10 you can refer to the same row. Default: 0.

Number         (optional) Column level (0= bottom level or innermost group, 1= next lowest, ...). Using -10 you can refer to the same column. Default: 0.

Number         (optional) Value index (0= first value, ...). Default: 0.

Return value:

Number

Example:

Crosstab.Cells.Avg(True,2,0) Result: mean value of the cell contents.