...
To perform a simple counting of non-nulls without conditionals, use the COUNTA function. See COUNTA Function.
| D s | ||
|---|---|---|
|
| d-codelang-syntax | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| COUNTAIF
| |||||||||
countaif(entries, entryValidation == 'Ok') |
Output:
...
Returns the count of non-null values in the entries
...
column when the entryValidation value is 'Ok'.
...
| D s | ||
|---|---|---|
|
| d-code-lang-syntax | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| COUNTAIF
| |||||||||
countaif(col_ref, test_expression) [group:group_col_ref] [limit:limit_count] |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| col_ref | Y | string | Reference to the column you wish to evaluate. |
| test_expression | Y | string | Expression that is evaluated. Must resolve to true or false |
...
