reporting-servicescountexpressionssrs-expression

Count expression SSRS Report

Trying to count all rows in a column where column=Yes I have two columns in my report Accepted and rejected.

I'm trying to count the rows where accepted=Yes and do the say thing for rejected.

I've tried these:

=COUNT(IIF(Fields!accepted.Value="Y",1,0))
=COUNT(IIF(Fields!rejected.Value="Y",1,0))   
=COUNT(FIELDS!accepted.value="Y")
=COUNT(FIELDS!rejected.value="Y")

this expression is counting every row as opposed to just the ones that are "Y"

Solution

  • You can do this a couple of ways:

    SUM(IIF(Fields!accepted.Value="Y",1,0))

    or

    COUNT(IIF(Fields!accepted.Value="Y",1,Nothing))

    COUNT is a count of all Rows, so even by returning 0 it will get included in the count. This is why returning Nothing should do the trick.