Count Null Values

Hi
How do I count Null and non null values in reporting services...'
Thanks
Carlos AntonioThis will count all rows where the value of the X-field is not null:
=Count(Fields!X.Value)
You may also want to check the CountDistinct(...) aggregate function.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"C a r l o s - A n t o n i o" <carlvazpr?arroba¿yahoo.com> wrote in message
news:eVqO6h2oFHA.3316@.tk2msftngp13.phx.gbl...
> Hi
> How do I count Null and non null values in reporting services...'
> Thanks
> Carlos Antonio
>|||You can also do counts via the SUM function with a nested IIF like
this:
// This counts NOT NULL values
=SUM(IIF(Fields!MyField.Value = Nothing, 1, 0))
// This counts NULL values
=SUM(IIF(Fields!MyField.Value = Nothing, 0, 1))
Lance
http://www.lance-hunt.net|||Sorry, my comments are backwards...
// This counts NULL values
=SUM(IIF(Fields!MyField.Value = Nothing, 1, 0))
// This counts NOT NULL values
=SUM(IIF(Fields!MyField.Value = Nothing, 0, 1))sql