Small function
Applies to: TBM Studio 12.0 and later
Returns the smallest value in a specified column.
Where to use
This function can be used in:
- Data sets (with column, rollup)
- Calculated metrics and reports with metric columns (with rollup operators)
- Formula columns in report tables (with column)
- In any modeled object's unit driver or in any grouped table.
Syntax
Small([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 smallest number from.
Return type
The same as the type of column.
Examples
=Small(@Desktop)
=Small(Desktop)
See also: