Special Functions

 

 

Function

Purpose

Crosstab.Cells.Max() or Crosstab.Cells.Min()

Returns the largest or smallest value of the cell contents.

Crosstab.Cells.Avg() or Crosstab.Cells.Sum()

Returns the mean value or sum of the cell contents.

Crosstab.Col$()

or Crosstab.Row$()

Returns the label for the column or the row currently being output.

Crosstab.Col()

or Crosstab.Row()

Returns the index for the column or the row currently being output.

Crosstab.Value()

Returns the value of a cell.

Crosstab.Total()

Defines the value of the corresponding total column of a cell.

Join$()

Returns a collection of strings, separated by a particular character.