NonEmptyCount

Returns the count of the number of tuples in a set that evaluate to non #Missing values.

Syntax

NonEmptyCount ( set [,numeric_value_expression ] )

set The set in which to count tuples.
numeric_value_expression Optional expression.

Description

Each tuple is evaluated and included in the count returned by this function. If the numeric value expression is specified, it is evaluated in the context of every tuple, and the count of non #Missing values is returned.

Example

The following query

With 
Member [Measures].[Number Of Markets]
as 'NonEmptyCount (Market.Levels(0).Members, Sales)'

Select 
{[Measures].[Number Of Markets]} on Columns,
{[100].Children, [200].Children} on Rows
FROM Sample.Basic

Returns the grid:

Number of Markets
100-10 20
100-20 16
100-30 8
200-10 20
200-20 17
200-30 9
200-40 3

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com