DCOUNT

Syntax

DCOUNT (Dimension, {Condition})

Description

The DCOUNT function returns the number of members in Dimension for which Condition is true. If Condition is omitted, DCOUNT returns the number of members in Dimension.

Returns

The number of members in Dimension for which Condition is true. If Condition is omitted, DCOUNT returns the number of members in Dimension.

Example

Suppose an analytic model contains a data cube called UNITS_SOLD that uses a dimension called PRODUCTS. Use the following formula to find the number of products that sold more than 5000 units:

DCOUNT(PRODUCTS, UNITS_SOLD > 5000)

For an example of how to tabulate data for a series of ranges, see the entry for the DAVG function.