Small function
Returns the smallest value in a specified column.
Syntax
Small([rollup_operator]column)
Parameters
rollup_operator
@, SOURCE, ~, or TARGET. This argument is optional and used only with metrics. See Rollup Operators.
column: The column to search for the smallest value. You may specify a table prefix using TableName:ColumnName. Required
Behavior
Scans the specified column and returns the smallest (minimum) value.
Return type
Number
Examples
=Small(@Desktop)
=Small(Desktop)
Small(Budget): Returns the smallest value from the 'Budget' column.
Small(Financials:Cost): Returns the smallest value from the 'Cost' column
in the 'Financials' table.