Add a column to the child table with the proportion broken. One line would have 0.6 and another 0.4 for example. The total is multiplied by these amounts. As long as each separate account totals 1.0, there should be no problem. Let me know if that works.