question

CliveWightman-8621 avatar image
0 Votes"
CliveWightman-8621 asked CliveWightman-8621 answered

SSRS Count Expression not Working

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
image.png (2.7 KiB)
image.png (6.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CliveWightman-8621 avatar image
1 Vote"
CliveWightman-8621 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.