Catagory averages are effecting each other , What to do?
Posted by Charles on January 18, 2002 4:31 PM
I am using this formula.
I have several single grades that are averaged into various catagory grades that are then averaged into a final grade.
The above formula is alowing my catagory grades to effect each other.
If I have a score of 100 in a single catagory called WEX everything is OK, but when a second catagory WEL gets an average of 50 they effect each other. WEX drops to 50 and WEL shows up as 25. Does anyone know how I can fix this?