Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

?? on =count adding a "When" Expand / Collapse
Author
Message
Posted Wednesday, April 03, 2013 9:19 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 267, Visits: 424
using this expression on a total in a matrix

=count(Fields!xmark.Value)
can I add a condition onto this so it only counts xmark when it = 'X' or = 'D' ?

Thanks in Advance

Joe

Post #1438427
Posted Wednesday, April 03, 2013 9:41 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 267, Visits: 424
Hey.. I actually figured it out !!! lol!!


=sum(iif(Fields!xmark.Value ="X" or Fields!xmark.Value ="D", 1,0))
Post #1438443
Posted Wednesday, April 03, 2013 11:21 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, March 17, 2014 11:46 PM
Points: 17, Visits: 30
It's correct !!!!!!
Post #1438648
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse