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

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

Name

Ajay

Alice

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

Name

Min_Number

Name

Min_Number

Ajay

27087

Alice

14489