Find the smallest records in each category
smallest 10 CURBAL
smallest 5 CURBAL (CURBAL gt 0)
smallest 3 CURBAL STATE
smallest 3 CURBAL STATE (PROPTYPE eq 'SF')
smallest RecCount NumField (Category) (SelectionStatement)
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| RecCount | Numeric | Field, Constant | Number of records | No | |
| NumField | Numeric | Field | Measurement Field | No | |
| Category | Text | Field | Grouping field | Yes | |
| SelectionStatement | Boolean | Field | Expression to select records that will be applied to the calculation. | Yes | 1 |
Type: Boolean
1=selected, 0=not selected