Looks Like You have Discrepancy in Employee names in both of your Sheets.
Thank you Deepak for your reply.
I am working the data from 2015-2017. So, the employee IDs and names are sometimes repeated. Do you think the discrepancy could be because of that?
Anything else I can do to calculate the rate?
Did you tried Joining Data?
I tried blending the data but could not make it work. I will give one more shot.
After I blend, can I just divide the nominated employees by the total employees and use department, location as filters? Because we cannot divide location from nominated employees and total employees because they are string values, right?