Sum and average over null values SQL Server 2008 Analysis Services

Posted by Jonathan on Stack Overflow See other posts from Stack Overflow or by Jonathan
Published on 2010-05-19T13:45:01Z Indexed on 2010/05/19 14:00 UTC
Read the original article Hit count: 175

Filed under:
|
|

I have a simple problem, I think, but I have googled and can't find the solution. I have a cube that has MeasureA, MeasureB and MeasureC. Not all three measures have values for each record, sometimes they can be null, it's depending if it was applicable.

Now for my totals, I need to average but the average must not take nulls into account. Any help will be much appreciated. When I view the measures, the null values show as zeros.

© Stack Overflow or respective owner

Related posts about sql

Related posts about sql-server-2008