The Count function returns the number of non-Null and non-empty values within a column or group.

Syntax

Count(\[Field\])

Arguments:

  • Field (optional) The column of values to be counted. Null values are skipped.
    • If not supplied, Count() returns the number of rows in a table.

Examples

Count()

  • Counts number of rows in a table.

Count(\[Funding Total Usd\])

  • Counts number of companies with a disclosed funding total.