title: SSRS- how SUM function ignore negative values
body: <p>i want to add only positive values in a aggregate function, i.e. sum. it should only add positive value. what i am doing is</p>
  
  <blockquote>
    <p><strong>SUM(((Fields!MonthlyTarget.Value-Fields!MonthToDateUnits.Value-Fields!DUSales.Value)/(Fields!RemaningDays.Value+1)))</strong></p>
  </blockquote>
  
  <p>but now i want to ignore the negative values to add. </p>