Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSRS counting column total based on conditional boolean

Status
Not open for further replies.
mjd3000

mjd3000

Programmer
Apr 11, 2009
136
GB
Hi,

I have a column like this :

BooleanColumn:
Yes
No
No
Yes
Yes

And for my total for this column I need to count only the records where the boolean value is true (in this case it would be 3). Does anybody know how to do this?
 
Sort by date Sort by votes
This should do the trick:
Code: 
SELECT SUM(CASE WHEN BooleanColumn = 1 THEN 1 ELSE NULL)
FROM TABLE

[morning]
 
Upvote 0 Downvote
Sorry, this should've been posted in Reporting Services forum.

Apologies,

Mike
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

peac3
  • Locked
  • Question
Avoid double counting 1
Replies
16
Views
463
peac3
peac3
coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
304
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
Conditional Foreign Key Constraint
Replies
1
Views
144
Chris Miller
Chris Miller
Virendra Yaduvanshi
  • Locked
  • Question
SSRS - Subscription page error
Replies
0
Views
107
Virendra Yaduvanshi
Virendra Yaduvanshi
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
342
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top