4 Replies Latest reply: Jul 19, 2014 5:22 AM by Neeraja Nagreddy RSS

    SUM 2 fields on 2 conditions...

      OK, I have a question re: summing. I want to SUM [Contract Value] when Stage is 'Contract' and add this to the SUM of [Pipeline Value] when Stage is 'Contract Negotiation' or 'Offer Negotiation'.

       

      I've seen conditional sums in here, but they are typically summing one field when multiple conditions exist. Here I need to sum 2 fields when 2 or more conditions exist.

       

      Any help would be greatly appreciated!