title: How to make #Error to Empty in RDLC Report Expressions?
body: <p>My Report had <code>AmountColumn(Fields!Amount) &amp; Amount%Column</code>. I am calculating Grand Total for both the columns using expressions.</p>
  
  <p>I am getting #Error in <code>GrandTotal of Amount%Column</code> when <code>AmountColumn</code> is Empty.
  How to make GrandTotal of Amount%Column as Empty instead of <strong>#Error</strong>.</p>
  
  <p>My Expression Showing #Error:</p>
  
  <pre><code>=FormatNumber(Sum(CDec(Fields!Amount.Value))/Sum(CDec(Fields!Amount.Value),"Tablix2")*100,4)
  </code></pre>