Maths functions

GROUPFIRST – Identify first record in group

267 views June 1, 2018 admin 0

Overview

This Custom Field returns the value of a given field for the first record in a group.

Syntax

GROUPFIRST(‘GroupPath‘,’SortField‘,’FieldValue‘)

Element Description
GroupPath Group path, delimited by colons.
SortField The field to sort the records in the group by.
FieldValue The field that to retrieve the value from.

Example

GROUPFIRST(‘Parent Category:Child Category‘,’Price‘, ‘Colour‘)

This command will first sort the ‘Price’ field into ascending ‘Price’ order and return the first associated colour Red.

Colour Price
Yellow 12.80
Red 11.00
Blue 17.79

See also

GROUPCOUNT

GROUPCOUNTUNIQUE

GROUPAVG

GROUPMAX

GROUPMIN

GROUPSUM

GROUPRTOTAL

GROUPLAST

GROUPISFIRST

GROUPISLAST

 

Was this helpful?