I am trying to create an OLAP Cube measuring Tickets, Time, AvgDuration
and other Average measures for analysis in Excel PivotTable Services
WITH DRILLDOWN. I need to create a measure on Average Duration. Some of
these Duration values are null. If I use the traditional Sum(Duration) /
Count(Tickets), the result is too high because it includes null values.
The Avg function excludes null values. Can anyone demonstrate how to
create a measure using the Avg() function or even the VBA Excell
AVERAGE() funtion excluding nulls? I would like to be able to create a
DERIVED MEASURE if possible.

Thanks



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!