Count(not null)?

Is there anything equivalent to a SQL count(col) which will only count the non-null values?

Workaround is to create 1/0 columns that can be aggregated via sum() … but it would be nice to have the SQL-style count().

Thanks. John

Any update on this? I find myself needing to do this calculation all of the time, and not having a simple count() function available is super frustrating.