Table of Contents
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