Grouping data

GROUPONCHANGE – Identify field changes

30 views June 1, 2018 admin 0

Overview

This Custom Field returns TRUE every time a field changes, and returns FALSE otherwise.

Syntax

GROUPONCHANGE(‘GroupPath‘, ‘SortField‘, ‘CheckField‘)

Element Description
GroupPath Group path delimited by colons.
SortField Field to sort by.
CheckField Field to check for changes.

Example

GROUPONCHANGE(‘Parent Category:Child Category‘, ‘Price‘, ‘Price‘)

Price GROUPONCHANGE
$1.95 TRUE
$2.95 TRUE
$3.25 TRUE
$3.25 FALSE
$4.00 TRUE

See also

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

Was this helpful?