Group Row Index
Description
An index or numbering applied to rows within a group to indicate their position or order.
Calculation Editor
Options
| Input Parameter Values | Input Values |
|---|---|
| Only Rollup If | Generic Criteria |
Input
| Input Column | Input Values | Required |
|---|---|---|
| Input 1 | Column | ✔ |
Example
Let's say you want to only return the first record found within each grouping of a column. You can do this using the Group Row Index calculation.
- Create an F0411 report with Address Number (or the associated description - Vendor Name field) grouped.
- Right-click on the Address Number column and select Quick Calculations > System > Group Row Index
- Notice that in the expanded group state, you are able to easily view the row index only within that grouping. As soon as a new grouping starts, the row index resets to 1 as well.
- To only return the first record from each grouping, you can then filter the Group Row Index field to 1. Once the filtering is complete, feel free to hide that field so it's not visible in your report.