Grouping data

GROUPMAX – Identify maximum value in a group

212 views June 1, 2018 admin 0

Overview

This Custom Field returns the maximum value of a given field in a group.

Syntax

GROUPMAX(‘GroupPath‘,’MaxField‘)

Element Description
GroupPath Group path, delimited by colons.
MaxField The field in which to search for the maximum value.

Example

GROUPMAX(‘Parent Category:Child Category‘,’Price‘)

Price GROUPMAX
$1.95 $6.50
$6.50 $6.50
$4.40 $6.50
$2.95 $6.50
$3.25 $6.50

See also

GROUPCOUNT

GROUPCOUNTUNIQUE

GROUPAVG

GROUPMIN

GROUPSUM

GROUPRTOTAL

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

 

Was this helpful?