SSRS Multiple Criteria In Countrows IF Expression

1
votes

I'm having trouble putting 2 criteria into a countrows expression in report builder 3.0, I'm sure its something very simple or impossible but I just can't do it! I only want to bring back values which meet the 2 criteria below in one single expression.

=Sum(IIF(Fields!COL1.Value = "X", 1, 0)) AND =Sum(IIF(Fields!COL2.Value = "Y", 1, 0))

1
sqlreporting-servicesexpressionreportbuilder3.0

1 Answers

1
votes

Just combine them as one IIF :

Sum(IIF(Fields!COL1.Value = "X" and Fields!COL2.Value = "Y", 1, 0))