rhservan
asked on
How does SSAS interpret NULL & Zeroes regarding counts?
I have a measure where the data in the column is based on currency. The results of the stored procedure which creates this column and inserts data looks like this:
<blank> Stored Procedure uses a CASE statement and the ELSE is NULL (is <blank> correct?)
0.00
130.00
I want to perform a count on everything that IS NOT NULL.
How can I do this in my cube?
<blank> Stored Procedure uses a CASE statement and the ELSE is NULL (is <blank> correct?)
0.00
130.00
I want to perform a count on everything that IS NOT NULL.
How can I do this in my cube?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ignore question above this one.
Do aggregate functions count on zeroes?
Do aggregate functions count on zeroes?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if you want your count to ignore zero values as well as null's then try something like this...
select count(case when your_column = 0 then null else your_column end) from your_table
select count(case when your_column = 0 then null else your_column end) from your_table
ASKER