Large function
Returns the largest value in a specified column.
Syntax
Large([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 largest value. You may specify a table prefix using TableName:ColumnName. Required
Behavior
Scans the specified column and returns the largest (maximum) value.
Return type
Numeric
Example
Large(Budget): Returns the largest value from the 'Budget' column.
Large(Financials:Cost): Returns the largest value from the 'Cost' column in the 'Financials' table.