Welcome to Catalog Tips

Search more than 200 articles to learn more about creating and automating your product catalogs

Tip: Start typing in the input box for immediate search results.

< All Topics
Print

GROUPMAX – Identify maximum value in a group

Overview

This Custom Field returns the maximum value of a given field in a group.

Syntax

GROUPMAX(‘GroupPath‘,’MaxField‘)

Element Description
GroupPath Group path, delimited by colons.
MaxField The field in which to search for the maximum value.

Example

GROUPMAX(‘Parent Category:Child Category‘,’Price‘)

Price GROUPMAX
$1.95 $6.50
$6.50 $6.50
$4.40 $6.50
$2.95 $6.50
$3.25 $6.50

See also

GROUPCOUNT

GROUPCOUNTUNIQUE

GROUPAVG

GROUPMIN

GROUPSUM

GROUPRTOTAL

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

 

Table of Contents