Count Null Values

[C a r l o s - A n t o n i o]

Hi

How do I count Null and non null values in reporting services....????

Thanks

Carlos Antonio

[Robert Bruckner [MSFT]]

This 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:eVqO6h2o...@tk2msftngp13.phx.gbl...

[Lance]

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

[Lance]

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))