8 Replies Latest reply on Mar 31, 2017 6:42 AM by Michael Someck

    Adding Parent and Subsidiary company costs together

    Paul Creamer

      Hello,

       

      I have a set of pricing data that has both the parent and subsidiary data included. I would like to be able to combine the parent and subsidiary price to get the total price. So for example, total cost for Subsidiary 1 would be $15, and Subsidiary 3 would be $18 etc.

       

      Here is a very simplified sample of the data:

       

      NameParent IDPrice
      Parent 110$10.00
      Parent 220$11.00
      Parent 330$12.00
      Subsidiary 110$5.00
      Subsidiary 210$6.00
      Subsidiary 320$7.00
      Subsidiary 420$8.00
      Subsidiary 530$9.00

       

      Any help would be much appreciated!

       

      Thanks

       

      Paul