1 2 Previous Next 16 Replies Latest reply on Oct 4, 2013 3:01 AM by . Indumon

    Calculation of reallocation

    Camille Cosnefroy

      Hello,

       

      I would like to do this calculation in order to reallocate sales of the product C in A and B.

      The reallocation for the product A is in proportion of the share of A in A+B, and the reallocation of the product B is in proportion of the share of B in B + A

       

      ProductSalesReallocated sales
      Product Axx + x/(x + y) * z
      Product Byy + y/(y+x)*z
      Product Cz0

       

      I have some difficulties because I need values which are not in the lines.

      Thanks for your help,

       

      Cam

        1 2 Previous Next