Grouping data

GROUPRTOTAL – Calculate running total

152 views June 1, 2018 admin 0

Overview

This Custom Field returns the running total of a given field in a group.

Syntax

GROUPRTOTAL(‘GroupPath‘, ‘SortField‘, ‘CheckField‘)

Element Description
GroupPath Group path delimited by colons.
SortField Field to sort by.
CheckField Field to total.

Example

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

Price GROUPTOTAL
$1.50 $1.50
$2.00 $3.50
$3.25 $6.75
$3.25 $10.00
$4.00 $14.00

See also

GROUPCOUNT

GROUPCOUNTUNIQUE

GROUPAVG

GROUPMIN

GROUPSUM

GROUPRTOTAL

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

GROUPONCHANGE

Was this helpful?