COUNT
Usage
Use this function to return the cardinality of a given column. You can apply a restriction or include null values or not with a boolean condition (true / false)
| Category | Function | Type | Where to use | Argument statement |
|---|---|---|---|---|
| FUNCTION | SERVER STORAGE | NUMERIC | .VALUE |
Syntax
1 | |
Arguments
#Storage
the storage entity name
#Storage.Counted_Column
the column whose items would be count
#Storage.Condition_Column (optional)
the column field to check the restriction condition
Value (optional)
any cell value (#Storage_Name.Field_Name.VALUE or .OLDVALUE), constant, System Variables or function-returned value
true / false (optional)
true to include NULL values, false to exclude NULL values
Return Value
Integer
Examples
Example 1
Formula
=COUNT(
#StorageExample;
#StorageExample.Company;
#StorageExample.Customer == true;
false
)
Description Return the count of column Company of StorageExample where Customer is true (so the Company is a Customer) and exclude NULL values
Result Count of Companies that are Customers