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 |
---|---|
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 |