[AccessD] Math problem??

Hi Jim

Isn't this a normal rounding issue?
If you calculate the final grading as:

  FinalGrading = Int(AverageGrading + 0.5)

you will get an "O" for an average grading of 4.7.

/gustav

> We have an automated employee evaluation form that allows supervisors/managers to grade their staff in 13 categories on the following scale:

> O               100 - 90
> V               89 - 80
> G               79- 70
> I               69 - 60
> U               Below 60

> There's been much discussion among management to change this scale to a 1 to 5 rating but given a sample of 10 evaluations changing each grade above to a 1-5 value does not end up with the same
> average over the 13 categories (in other words, on certain employees who averaged in the "O" or outstanding group the 1-5 average was 4.7 where I need it to be 5 to get them in the Outstanding
> rating).

> Is there a way for us to change our grading system without dropping certain grades from the (previously) correct bucket?