How Many Compliant Calls To Hit Target

[Faustus06]

Hi,

Our agents have a non compliant target of 6% or less. Using other formulas I have the total calls made and the number of non compliant calls and then the %.

For Example

Number of N/C calls Total Calls Current compliance
1 3 33%

If I manually do the calculation a total of 17 compliant calls are needed to bring the % under 6.00% so a further 14 compliant calls are required providing none of them are non compliant.

Any way to do this automatically?

Thanks

[etaf]

=ROUNDDOWN(C2/B2*100,0)
where B2 is the total number of calls and C2 is the number of non compliant call

=ROUNDDOWN(B2*0.06,0)
calculates the 6% number

so you could then just use them together

=ROUNDDOWN(B2*0.06,0) - ROUNDDOWN(C2/B2*100,0)

which will tell you how many are left

I have used rounddown - so that if you have 3.9 then it rounds down to 3 - to get the integer value of the number
if you are happy with decimals
just use

=(B2*0.06) - (C2/B2*100)

you could add an IF to test if they have already exceeded 6% and mark as fail
or say how many they are over - which this will do as a negative number anyway

[Pete_UK]

You could use this formula, e.g. in D2:

=ROUNDUP((A2-6%*B2)/6%,0)

Hope this helps.

Pete