title: IIF Statement Not Returning a Value in SSRS
body: <p>I'm very confused by this situation, i've written quite a few IIF statements and always get them to work.  I have two columns in my dataset called CATEGORY and PCT, what i'm trying to do is return the PCT value for only one specific value in CATEGORY.</p>
  
  <p>For example, I have the following table of data </p>
  
  <pre><code>Category    PCT
  A           .50
  B           .75
  </code></pre>
  
  <p>I have placed a textbox on my report and have written the following expression to return the PCT value if Category = B, like so:</p>
  
  <pre><code>=IIF(Fields!Category.Value = "B", Fields!PCT.Value, " ")
  </code></pre>
  
  <p>For some reason this expression returns empty every single time.  When I just put Fields!Category.Value in the textbox as a test then the value A returns which is as expected.  </p>
  
  <p>I'm really thrown-off by this and I know i'm missing something very simple - can someone help?</p>