Grouping data

GROUPSERIES – Populate a group with a numerical series

108 views June 1, 2018 July 26, 2018 admin 0

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

See also

GROUPSEQUENCE

GROUPNUMBERSEQUENCE

GROUPSEQUENCEONFIELDCHANGE

Was this helpful?