If It is 0, then use this Calc:
you will get single value per agent
It is in Percentage form. Try to convert it in Number format then you'll get any idea about it.
Here you can attach your workbook so that people could help you in Broader way.
Thanks for your response. Unfortunately, the tbw contains confidential data, and it would have taken quite a long time to randomise it. Next time I will be prepared for this eventuality.