count (aka cnt)
To return the number of concrete items in an array
With this function, you can count the number of entries in arrays or tables that are not
nullor empty strings ("").
If you'd like to count all items in your array, we recommend using
In combination with
select ... whereyou can count records that meet a specific condition. For example, how many entries have the status open, or how many last names start with a B.
The function can also be very helpful to find out if there are any duplicates in your table.
count("A", "B", "")
count(select Invoices where Total >= 1000)
(if the table Invoices contains 98 records, where the Total is greater than USD1,000)
let ids := (select Contact).'Customer-Id';
cnt(ids) = cnt(unique(ids))
Return: If all IDs are unique, the result is Yes (
true). If there are duplicates, the result is No (