title: How to Sum Visible Rows Only SSRS
body: <p>I am trying to sum only the visible rows only in SSRS and I have read a few forums that say you need to put:</p>
  
  <pre><code>=Sum( iif( &lt;The condition of Visibility.Hidden expression&gt;, 0, Fields!A.Value)) 
  </code></pre>
  
  <p>However I am unsure on how this works, my visibility code is:</p>
  
  <pre><code> =iif(Fields!Sub.Value = "Ins", True, IIF(Fields!Sub.Value = "Ins - Int", True, False))
  </code></pre>
  
  <p>When I add this into the above 1st code i get #ERROR.</p>
  
  <p>Appreciate any help.</p>
  
  <p>Thanks </p>