Count

Return to: Calculated Member Builder Function List

Returns the number of tuples in a set, empty cells included unless the optional EXCLUDEEMPTY flag is used.

Syntax

Count(«Set»[, EXCLUDEEMPTY | INCLUDEEMPTY])

Note Empty cells are counted by default. The comparable Count function in OLE DB excludes empty cells by default.

Remarks

To exclude empty cells, use the optional EXCLUDEEMPTY keyword.

Example

If Time has levels Year and Month, and the members of Year are 1994 and 1995, then:

Count({Time.Month.Members})

returns 24.