title: How to sum values in Reporting Services via Visual Studio 2008 Expression Designer?
body: <p>I have a report like this</p>
  
  <pre><code>person | lead count | support count | ...
  p1     | 10         | 20            | ...
  p2     | 20         | 30            | ...
  </code></pre>
  
  <p>I need to have sum of counts in one column. I've tried this expression:
  <code>=Sum(IIf(ISNOTHING(Fields!lead_count.Value) Or Fields!lead_count.Value = "", 0, Fields!lead_count.Value))</code></p>
  
  <p>but it gives me <code>#Error</code>, aswell as trying:
  <code>=Sum(IIf(ISNOTHING(Fields!lead_count.Value) Or Fields!lead_count.Value = "", 0, Int(Fields!lead_count.Value)))</code></p>
  
  <p>Any ideas what I am doing wrong and how to get proper sum of counts (30 for lead, 50 for support)?</p>