aggregate
Syntax:
Number
Context Filtering: ✗ No
Parameters
Allowed Column Types for
column: INT, FLOAT, DECIMAL, DATE, DATETIME
Validation
- Minimum parameters: 2
- Maximum parameters: 2
Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
aggregate
Syntax:
MinIf([column], condition)
Number
Context Filtering: ✗ No
| Name | Type | Required | Description |
|---|---|---|---|
column | column | ✓ Yes | The column to find minimum value from when condition is True |
condition | logical | ✓ Yes | Logical expression evaluated per row |
column: INT, FLOAT, DECIMAL, DATE, DATETIME
MinIf([Sales], [Region] = "North")