7 Replies Latest reply on Apr 4, 2017 12:19 PM by Guy Adams

    Sum All Products If Includes Specific Product

    Guy Adams

      I'm sure this is a very simple solution, but I just cannot figure it out.

       

      I want to sum the total Increment ID Product Sales, if the Increment ID includes Product A or Product B in the Name (Catalog Product Flat 1).

       

      Example:

      Product SalesIncrement IdName (Catalog Product Flat 1)
      $12.31100008B1SProduct C
      $4.70100008B1SProduct C
      $2.33100008B1SProduct A
      $19.34

       

       

      I'm using 10.1.5

       

       

      Thanks,

       

      Guy