Don't know why but I an unable to recreate your issue.
I tried to calculate the Client Services %, but dont know if these is the correct formula you are using.
When I am using this formula it is not calculting the correct arithmetic means. So dont know if the formula you provided is correct.
Also looking at the formula it calcualtes the value only for the client services therefore you are able to see the data in you table for client services only and adding blank for rest of the departments.
You will have to provide me the exact steps you used , so that I can recreate the same in my system.
As you mentioned the main issue I am having is that currently my forumla is calculating the value only for the client services therefore I am able to see the data in my table for client services only and adding blank for rest of the departments.
I do not have the knowledge to extend my formula to include the other departments? Can you advise on how I could extend the formula to include those?