Count expression SSRS Report

Question

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"

score 48 · Accepted Answer · answered Mar 04 '13 at 15:10

48

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.

answered Mar 04 '13 at 15:10

Tom Jenkin

1,925
2
15
11

Thanks. I was overthinking the count, I didn't want to sum them but that makes sense as I'm converting if its Yes to a 1 – Jt2ouan Mar 04 '13 at 15:31

bubbles · Answer 2 · 2017-07-21T16:11:50.553

3

=SUM(IIf(Fields!Doc_Type.Value = "Shipments", 1, 0), "YourDataSetName")

this worked for me with no errors. saw this on another post.

edited Jul 21 '17 at 16:11

answered Jul 21 '17 at 16:06

bubbles

31
2

score 0 · Answer 3 · answered May 28 '19 at 09:52

0

You can try to use "And" Operators to check both conditions together.

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

answered May 28 '19 at 09:52

Lily

1
1

Count expression SSRS Report

3 Answers3

Linked