This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
To count not null values with positive numeric values:SUM(IF(my_field >=
0, 1, 0)) or if you also have negative values:SUM(IF(my_field >= 0, 1,
0)) + SUM(IF(my_field < 0, 1, 0)) With string
values:SUM(IF(LENGTH(my_field) >= 0, 1, 0))To count null
val...