Description:
Count the number of non-null members in a sequence.
Syntax:
|
A.count() |
Equivalent to count(x1,…,xn) |
Note:
The function counts the number of the non-null members in the sequence A.
Parameters:
|
A |
A sequence whose length is n |
Return value:
An integer, which is the number of the non-null members in the sequence A
Example:
|
|
A |
|
|
1 |
=[1,2,3,4].count() |
4 |
|
2 |
=[1,null,3,4].count() |
3 |
|
3 |
=count(1,null,3,4) |
3 |
Related functions: