Grouping data

GROUPMIN – Identify minimum value in a group

169 views June 1, 2018 admin 0

Overview

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

Syntax

GROUPMIN(‘GroupPath‘,’MinField‘)

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

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

Example

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

Price GROUPMIN
$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

GROUPMAX

GROUPSUM

GROUPRTOTAL

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

 

Was this helpful?