/
GROUPMIN

GROUPMIN

Syntax

GROUPMIN(<number>)

Description

Returns the minimum values in a group. A GROUPBY() function must first be used in order to then find the minimum arguments of another column in relation to it.

This is an aggregate function.

Example

Given the following data:

Name
Number
Ajay27087
Ajay55317
Alice14489
Ajay31310
Ajay57822
Ajay63855
Alice47640
Alice48979

First create a group using GROUPBY(#RawData!Name).

Name
Ajay
Alice

Then use GROUPMIN(#RawData!Number) to return the minimum values of the Number column.

Name
Min_Number
Ajay27087
Alice14489

Related content

GROUPMIN
More like this
GROUPMIN
More like this
GROUPMAX
GROUPMAX
More like this
GROUPMAX
More like this
GROUPMAX
More like this
GROUPBOTTOMN
GROUPBOTTOMN
More like this