# Achievement calculation

#### 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.

#### Attachments

• ranking.xlsx
10.4 KB · Views: 6
I'm not in front of a computer at the moment so can't see your workbook but in answer to your
where a person achieves 30% what is his achievement vs target of 20%?
Perhaps try this: 87.5%
That's 7/8
Target is 20% defect which is 80% success. Achievement is 30% defect which is 70% success.
Achievement of target is 70%/80%.
Arithmetically:
(100-30)/(100-20)

I'll get to look at your file later.

I'm not in front of a computer at the moment so can't see your workbook but in answer to your

Perhaps try this: 87.5%
That's 7/8
Target is 20% defect which is 80% success. Achievement is 30% defect which is 70% success.
Achievement of target is 70%/80%.
Arithmetically:
(100-30)/(100-20)

I'll get to look at your file later.
Thanks this helps I will try this

?

Awesome this helps thanks a ton