Table of Contents
Overview
This Custom Field adds the values of a given field in a group and returns the total of those values.
Syntax
GROUPSUM(‘GroupPath’, ‘FieldName’)
GROUPSUM(‘Parent Category:Child Category’,‘Price’)
| Element | Description |
|---|---|
| ‘GroupPath’ | Group path delimited by colons. |
| ‘SortField’ | The field whose values are to be added. |
Example
GROUPSUM(‘Parent Category:Child Category’,‘Price’)
In this example the total all of the Price fields Child Category grouping are added, with the total of all values returned for each value.
|
Price |
GROUPSUM |
|
12.00 |
51.00 |
|
17.00 |
51.00 |
|
22.00 |
51.00 |