title: exclude nulls in column SSRS
body: <p>new to SSRS</p>
  
  <p>I have table with column 1 is Department, and column 2 is The calculation </p>
  
  <p>For example sum of the cost...</p>
  
  <p>I have used the expression below to sum the cost</p>
  
  <p>but I want to exclude the department that are null, but its no joy..</p>
  
  <blockquote>
    <p>=Sum(IIF(Fields!ReturnOrder.Value = "1" + IsNothing(Fields!Department.Value) = 1, Fields!Cost.Value, 0))</p>
  </blockquote>
  
  <p>column 1 is still showing the null department. I do not wish to show this...</p>
  
  <p>I just want to have a column 1 showing the department names, that does not show the null rows.. and column 2 sum of cost where return value = 1 </p>
  
  <p>please help</p>