RonKyle (3/24/2015)
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.
It might be better to hold the count of associates for an account and assistant manager pair, and divide, since the count can be held exactly as an integer (maybe a tinyint) rather than as an approximation potentially occupying a little bit more store. And if managers can have multiple assistants and directors can have multiple managers a divisor would have to be held for each of those levels too.
Tom