Formula field that calculates average values based on same date and same name of agent

Indeed, I needed to create a summary report to get the average Quality score per Agent and per week. As you can see below, for week of 9/30/19, the weekly average score is 97.22%. The next thing to do is to have another column in that summary report which is a formula field (Badge Name) that compares that average value (97.22%) to another field and then display the corresponding badge name. How do we refer to that average value from the summary report in this formula field? Here is a sample formula:

Field name: Badge Name
Formula:
If([Quality Score(avg)]>=[Quality Benchmark],"Excellent Quality Score"

which means to say

If(97.22%>=95%,"Excellent Quality Score"