title: Reporting Services - Count Column Values if equals A
body: <p>I have a dataset called 'dsAllStuTargetData' - i'm trying to count the number of the 'A' values that appear in the column 'Target'.</p>
  
  <p>I'm doing this using a textbox with an expression, I can count the total number of values using the following:</p>
  
  <pre><code>=Count(Fields!Target.Value, "dsAllStuTargetData")
  </code></pre>
  
  <p>However when I try to count where the value equals 'A' it doesn't work.</p>
  
  <pre><code>=Count(IIF(Fields!Target.Value, "dsAllStuTargetData")="A",1,0)
  </code></pre>