I can see that you have already calculated percentage Amount Collected.
What is wrong with the calculation and what are you currently looking for? Can you take one of the collectors, for an example and work through with numbers to show what you want and what the expected result should be?
Thanks, for your help. I was able to find a sql query to prepare the data in the proper format.