Large function

Applies to: TBM Studio 12.0 and later

Returns the largest value in a specified column.

Where to use

This function can be used in:
  • Data sets (with column and rollup arguments)
  • Calculated metrics and reports with metric columns (with rollup argument)
  • Formula columns in report tables (with column and rollup arguments)

Syntax

Large([rollup_operator]column)

Arguments

rollup_operator

@, SOURCE, ~, or TARGET. This argument is optional and used only with metrics. See Rollup Operators.

column

The column to return the largest number from.

Return type

The same as the type of column.

Example

=Large(@Space)

=Large(Space)