COUNTDUPLICATES

COUNTDUPLICATES(array, include_first_instance, ignore_blanks)

Counts the number of duplicate elements in an array according to configurable rules.

COUNTDUPLICATES evaluates an array and returns the total count of duplicates. The behaviour can be customised using include_first_instance and ignore_blanks.

Parameters:

• array (Operand) – The array to check for duplicates. Must be a valid array type or object array.

• include_first_instance (Operand | bool) – Determines whether the first occurrence of each duplicate should be included in the count. If True, first occurrence and duplicates are counted; if False, only subsequent duplicates are counted

• ignore_blanks (Operand | bool) –

  Determines whether blank values (null or empty strings) should be ignored in duplicate

  counting.

Return type:

Formula

Returns:

A formula object evaluating to an INTEGER representing the count of duplicate elements according to the specified rules.

Raises:

• ValueError – If array is not an array type

• ValueError – If include_first_instance or ignore_blanks is not BOOLEAN

Examples

Counting duplicates including the first instance:

COUNTDUPLICATES(
    ["A", "B", "A", "C"],
    include_first_instance=True,
    ignore_blanks=False
)
# Returns 2
# Explanation:
# - "A" occurs twice → both counted
# - "B" and "C" occur once → not duplicates

Counting duplicates excluding the first instance and ignoring blanks:

COUNTDUPLICATES(
    ["A", "", "A"],
    include_first_instance=False,
    ignore_blanks=True
)
# Returns 1
# Explanation:
# - "A" occurs twice → only the second counted
# - Blank ignored

``array`` — accepted types

• BOOLEAN_ARRAY

• DATETIME_ARRAY

• DATE_ARRAY

• DECIMAL_ARRAY

• INTEGER_ARRAY

• OBJECT_ARRAY

• STRING_ARRAY

• TIME_ARRAY

``include_first_instance`` — accepted types

• BOOLEAN

``ignore_blanks`` — accepted types

• BOOLEAN

Return types

• INTEGER