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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

counting based on boolean condition 1

Status
Not open for further replies.
mjd3000

mjd3000

Programmer
Apr 11, 2009
136
GB
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
Add a calculated field, and in the expression put:
Code: 
=Iif(Fields!BooleanColumn.Value, 1, 0)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Vasu100
  • Locked
  • Question
Populate Dynamic table columns based on parameter drop down values selection in SSRS report
Replies
0
Views
779
Vasu100
Vasu100
BTrees
  • Locked
  • Question
Deploy SSRS Report to Multiple Folders on Report Server Portal at Once From Visual Studio
Replies
0
Views
287
BTrees
BTrees
DaveAd
  • Locked
  • Question
Additional column added on export to excel
Replies
0
Views
165
DaveAd
DaveAd
aa888817
  • Locked
  • Question
One filter from multiple columns SSRS
Replies
0
Views
208
aa888817
aa888817
ArKpt
  • Locked
  • Question
Hide column headers when there is just the chart on a page by itself in a tablix in SSRS-2008
Replies
0
Views
321
ArKpt
ArKpt

Part and Inventory Search

Sponsor

Back
Top