Table of Contents
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 |