I have no idea how to begin with this one.
I have 412 records in a table ($total = 412). Tomorrow it may be more or less. So the number changes.
My goal is to divide that number into percentages.
For example:
43% of $total will go to Matt. (82.4 records)
20% of $total will go to Amy. (152.44 records)
37% of $total will go to Jack. (177.16 records)
I'm basically trying to divide the total number to be assigned to different reps.
However, the next day I may need to divide the new $total into 4 parts, or maybe 5. But it will always equal 100% of the $total.
Any ideas of how this can be accomplished?