Maths functions

GROUPCOUNTUNIQUE – Count unique instances of field content

208 views June 1, 2018 admin 0

Overview

This Custom Field returns the number of unique instances of a fields content in a group

Syntax

GROUPCOUNTUNIQUE(‘Parent Category:Child Category’,‘Manufacturer’)

Element Description
‘Parent Category:Child Category’ Group path, delimited by colons
‘Manufacturer’ Field in which to count instances

Examples

For the table below, GROUPCOUNTUNIQUE(‘Category1ID:Category2ID:CollectionID’) will return 2 as there are 2 distinct/unique CollectionID rows.

Category1ID Category2ID CollectionID ProductName Price
25 136 1924 Apple 9.99
25 136 1924 Banana 11.00
25 136 1965 Cantaloupe 48.95
25 136 1965 Durian 29.99

See also

GROUPCOUNT

GROUPAVG

GROUPMAX

GROUPMIN

GROUPSUM

GROUPRTOTAL

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

Was this helpful?