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
Ajay	27087
Ajay	55317
Alice	14489
Ajay	31310
Ajay	57822
Ajay	63855
Alice	47640
Alice	48979

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
Ajay	27087
Alice	14489

Browser not supported