I'm going to be querying this table and coming up with two numbers.
The first number is going to be total entries cast for each program (by everyone)
The second number is going to be the average number of entries cast by each person per program (they can submit more than one entry).
So I have the following data:
Code: Select all
Total: 1193
Average: 5.97The total needs to be 20% of the final score and the average needs to be 80% of the final score.
So 1193 needs to hold 20% weight. The 5.97 needs to hold 80% weight.
My immediate thinking was to do 1193 * (20/100) and 5.97 * (80/100)
But this will just add weighting to each individual number, not to the final score to be calculated.
Any help?