COUNTUNIQUEOF function

  • 21 December 2021
  • 0 replies
  • 878 views

Userlevel 4
Badge +6
  • Community Manager
  • 20 replies

​​​Description

Returns the number of unique non-BLANK items of a Block.

 

Syntax

COUNTUNIQUEOF(Block)

 

Arguments

Argument Type Dimensions Description
Block

(required)

Any Any  

 

Returns

Type Dimensions
Integer No Dimension

 

Examples

Employee is a Dimension List:

Formula Result Description
COUNTALLOF(Employee) 4

The Employee List contains 4 items. All items in a list are counted as unique.

COUNTALLOF(Employee.Name) 3 The Property Name contains 3 unique items.
COUNTUNIQUEOF(Employee.Team) 2 The Property Team contains 2 unique items.

 

See also

Related articles: COUNTOF, COUNTALLOF, COUNTBLANKOF

 

More of a hands-on learner? 

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace.  It includes examples of every formula and modifier in Pigment!

 

 


This topic has been closed for comments