0 Replies Latest reply: Sep 29, 2017 3:42 PM by gerry castellino RSS

    Calculation question

    gerry castellino

      Hello:

       

      Trying to get this calculation in a table.

      So the ETE% is a division  of Count of product a  by total count of All products for the Salesrep + added

      common products for other salesreps.

       

      So for example, the first line would be:

      10 / (10 + 10 + 10 + 20 + 20) = 14%.

       

      How do I count all the products for a Salesrep + add sales of common products to Salesrep James.

       

       

          

      SalesrepProductQty SoldETE%
      JamesA1014%
      JamesB1014%
      JamesC1014%
      JohnA2029%
      JohnB2029%
      JohnD20100%