



 
Hi Chris, Isn't it a good thing if less than 2 customers cancel in a month? As I see it, is 0, 1 or 2 contracts are cancelled that constitutes as 100% achievement of that target. As for the percentage of achievement for anything greater than 2, it would depend on the number of contracts: Here a is the total number of contracts, b is the number of cancelled contracts and the 2 represents the maximum allowable cancelled contracts. If you want to give someone who has less then 2 cancelled contracts an achievement percentage greater than 100%, this formula will work as well. Hope this helps, Janice
 


Math Central is supported by the University of Regina and The Pacific Institute for the Mathematical Sciences. 