title: SQL Server Report Builder SUM IF
body: <p>I have a table which display various data and what I want is it to calculate a percentage in which the total has increased by, so for example: 
  Total is £1000 
  TotalAfterMarkup is £1500</p>
  
  <pre><code>=SUM(Fields!Total.Value -  
  Fields!TotalAfterMarkup.Value) /       
  (Fields!TotalAfterMarkup.Value) 
  </code></pre>
  
  <p>the above code calculates the Percentage to -50% which is incorrect but ill be able to work that out. What i want is to now put this statement into an SUM IF statement. currently i get the #Error if the TotalAfterMarkup &lt; 1  so i need something like </p>
  
  <pre><code>IF TotalAfterMarkup.Value &gt;0 THEN
  
  =SUM(Fields!Total.Value -  
  Fields!TotalAfterMarkup.Value) /       
  (Fields!TotalAfterMarkup.Value) 
  
  ELSE 0.00%
  </code></pre>
  
  <p>is this possible, thanks for any help guys</p>