Special Functions

combit List & Label Designer

combit List & Label

Special Functions

Function

Purpose

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

Returns the largest or smallest value in the entire crosstab.

Crosstab.Cells.Avg()

Returns the average value for the entire crosstab.

Crosstab.Col$()
or Crosstab.Row$()

Returns the description of the column or the row for the current cell.

 

Crosstab.Value()

Returns the content of the cell (as a number).

Total()

You can use this function for calculations across all cells. Otherwise, calculations are always made across all values that affect the respective cell.

Join$()

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