Table of Contents
Overview
This Custom Field populates a group with a numerical series.
Syntax
GROUPSERIES(‘GroupPath’,‘SortField’, ‘Start’, ‘Increment’)
GROUPSERIES(‘Parent Category:Child Category’, ‘Price’, 10, 100)
| Element | Description |
|---|---|
| ‘GroupPath‘ | Group path delimited by colons. |
| ‘SortField’ | The field by which to sort. |
| ‘Start’ | An integer to start from. |
| ‘Increment’ |
A value to increase the integer by for each record in the group.
|
Example
GROUPSERIES(‘Parent Category:Child Category’, ‘Price’, 0, 50)
| PRICE | GROUPSERIES |
| 8.00 | 0 |
| 12.00 | 50 |
| 15.00 | 100 |
| 15.00 | 150 |
| 18.00 | 200 |