I have a query in which each row represents statistics for an individual person. I want to sum up the entire amount for a certain column and then use that to show percentages for each person.
Example:
Person | Number Completed
x | 20
y | 30
z | 50
From here I would love the sum of "Number Completed" (100) and then use that to add the field like so:
Person | Number Completed | Percentage Completed
x | 20 | 20%
y | 30 | 30%
z | 50 | 50%
I am having trouble thinking of ways to do this without the eval command as I have already gathered statistics "by Person" which is limiting me from gathering the statistics of the whole.
If you could help me out that would be greatly appreciated. Thanks!
... View more