title: SSRS - I want to add a filtered expression for a calculation
body: <p>--</p>
  
  <p>I would like to add and expression that calculates a value based on a certain value. I have a dataset with the name  DSSPend that has to columns one is the Area and the other spend. Now I would like to calculate the spend based on certain area values.
  I tried something like this but does not seem to work</p>
  
  <pre><code>=Iif((Fields!Area.Value, "DSSSpend") IN ('New York','Miami','Texas') = SUM(Fields!Spend.Value, "DSSSpend"), 0)
  </code></pre>