title: Crystal Reports Formula editing - Summing up a field by multiple conditions
body: <p>I have a report with 2 group names - Customers and Products
  I'm trying to sum up a field "Total" From Orders for each product by customer
  but i only want to sum the lines with specific fields values</p>
  
  <p>for example:
  If {OrderProducts.X} = Y And {OrderProducts.V} &lt;> W Then
  SUM({OrderProducts.Quantity},{Products.ProductID}) </p>
  
  <p>when using SUM with condition field i get the entire sum without any regards to the the above field values.</p>
  
  <p>i'd appreciate some help with this</p>
  
  <p>(I'm using Crystal Reports 2011)</p>