Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
COUNTN() is an aggregate function that only counts numbers. Any non-numeric value is ignored including NULL/MISSING.
The STRICT_COUNTN() version also counts only numbers. However, it returns NULL if NULL/MISSING value is encountered.