Grouping data

GROUPGETNTHPOPULATEDFIELDNAME – Display nth populated field in group

66 views June 1, 2018 admin 0

Overview

This Custom Field returns the nth populated field in the given group.

Syntax

GROUPGETNTHPOPULATEDFIELDNAME(‘GroupPath‘,n,‘Field1′,’Field2′,’Field3′,’Field4’)

GROUPGETNTHPOPULATEDFIELDNAME(‘Category:Subcategory‘,1,’Width’,’Height’,’Length’,’Price’)

 

Element Description
GroupPath Group path delimited by colons
n The required field index, e.g. n = 1 will return the 2nd value
‘Field1’, ‘Field2’, ‘Field3’… e.g. Width’,’Height’,’Length’,’Price’

Example

GROUPGETNTHPOPULATEDFIELDNAME(‘Category1ID:Category2ID,CollectionID’,0,Description,Bore Size,Model,Wire Size,Material,Tip Thread,Neck Thread,Length,Thread Size)

See also

GROUPCOUNT

GROUPCOUNTUNIQUE

GROUPAVG

GROUPMAX

GROUPMIN

GROUPSUM

GROUPRTOTAL

GROUPFIRST

GROUPLAST

GROUPISFIRST

GROUPISLAST

Was this helpful?