#### jaiprashanth

##### New Member

Hi,

I have a small issue in calculating achievement %. The situation is that we have a target of 20% or less when we are calculating defect % achievement. So in a situation where a person achieves 30% what is his achievement vs target of 20%? While ranking the same metric is given a weightage of 20%. So when calculating the ranking based on the weightage what is the achievement. I have attaching the working sheet. Any help would be welcome.

Thanks in advance.

I have a small issue in calculating achievement %. The situation is that we have a target of 20% or less when we are calculating defect % achievement. So in a situation where a person achieves 30% what is his achievement vs target of 20%? While ranking the same metric is given a weightage of 20%. So when calculating the ranking based on the weightage what is the achievement. I have attaching the working sheet. Any help would be welcome.

Thanks in advance.