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