Grouping data

GROUPISFIRST – Identify first n records

229 views June 1, 2018 admin 0

Overview

This Custom Field returns TRUE for a record in the first n positions of a group of records.

Syntax

GROUPISFIRST(GroupPath,SortField,Positions)

 

Element Description
GroupPath Group path delimited by colons. Limits the scope to the specified grouping.
SortField Field used to sort records by within the group.
Positions Optional field. The number of positions to be recorded. Defaults to 1.

Examples

GROUPISFIRST(Parent Category:Child Category,Colour,2)

Colour GROUPISFIRST
Red TRUE
Green TRUE
Red FALSE
Yellow FALSE

GROUPISFIRST(Parent Category:Child Category,Colour,3)

Colour GROUPISFIRST
Red TRUE
Green TRUE
Red TRUE
Yellow FALSE

See also

GROUPISLAST

GROUPFIRST

GROUPLAST

Was this helpful?