Maths functions

GROUPSUM – Calculate total of given field in group

340 views June 1, 2018 admin 0

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

See also

GROUPCOUNT

GROUPCOUNTUNIQUE

GROUPAVG

GROUPMAX

GROUPMIN

GROUPRTOTAL

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

Was this helpful?