Share via

SSRS Count Expression not Working

Clive Wightman 121 Reputation points
2021-06-14T15:50:45.563+00:00

Hi,

I have been going mad at trying to get this to work, but it just returns the full count and not the filtered count I'm trying for.

=COUNT(iif(Fields!PLT_CHECK.value=0,1,0))

and

=COUNT(iif(Fields!PLT_CHECK.value=1,1,0))

it 105369-image.png

105377-image.png

Please advice where I'm going wrong.

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,915 questions
0 comments
Accepted answer
  1. Clive Wightman 121 Reputation points
    2021-06-14T16:09:03.843+00:00

    Have got it to work =COUNT(iif(Fields!PLT_CHECK.value=0,1,0)) to =COUNT(iif(Fields!PLT_CHECK.value=0,1,Nothing))

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.