How is Trainee Rating calculated?

jd3737 · 3 weeks ago

I have a list of Coaching Assessments that have a Trainee Rating with decimal point values like 8.71 instead of 10. They answered each question with a Met value of 1, so shouldn't the Trainee Rating be 10 or at least a whole number?

Naveen20 · 3 weeks ago

Final assessment score calculated as a weighted average across categories, not a simple average of all individual question scores. So even if every question is answered "Met" (1), the math can produce decimals when:

Unequal number of questions per category — If Category A has 3 questions and Category B has 5, but both categories carry equal weight, the per-category contribution to the final score differs from a flat average of all questions.
Category weights don't sum cleanly — If you have categories with weights that don't distribute evenly (e.g., three categories each weighted at 33.33%), rounding in the calculation produces values like 8.71 instead of 10.
Some categories have zero or unanswered questions — If a category exists with a weight but no questions are answered in it, the denominator shifts and skews the result.

How to Investigate

Check the Assessment Metric Type record (asmt_metric_type) tied to these coaching assessments. Look at:

The Categories related list — see how many categories exist and what weight each one carries
Whether the category weights sum to exactly 100
How many metrics (questions) fall under each category
Whether any categories have no questions assigned

Then look at the asmt_assessment_instance or asmt_assessment_instance_question records for one of the affected assessments to see the per-category scoring breakdown.

Common Fixes

Adjust category weights so they sum to exactly 100 and reflect the actual question distribution
Remove empty or unused categories that may be absorbing weight without contributing scores
If you don't need category-level weighting at all, you can set all categories to equal weight or consolidate questions into a single category — that way a perfect score will cleanly equal 10

View solution in original post

Naveen20 · 3 weeks ago

Final assessment score calculated as a weighted average across categories, not a simple average of all individual question scores. So even if every question is answered "Met" (1), the math can produce decimals when:

Unequal number of questions per category — If Category A has 3 questions and Category B has 5, but both categories carry equal weight, the per-category contribution to the final score differs from a flat average of all questions.
Category weights don't sum cleanly — If you have categories with weights that don't distribute evenly (e.g., three categories each weighted at 33.33%), rounding in the calculation produces values like 8.71 instead of 10.
Some categories have zero or unanswered questions — If a category exists with a weight but no questions are answered in it, the denominator shifts and skews the result.

How to Investigate

Check the Assessment Metric Type record (asmt_metric_type) tied to these coaching assessments. Look at:

The Categories related list — see how many categories exist and what weight each one carries
Whether the category weights sum to exactly 100
How many metrics (questions) fall under each category
Whether any categories have no questions assigned

Then look at the asmt_assessment_instance or asmt_assessment_instance_question records for one of the affected assessments to see the per-category scoring breakdown.

Common Fixes

Adjust category weights so they sum to exactly 100 and reflect the actual question distribution
Remove empty or unused categories that may be absorbing weight without contributing scores
If you don't need category-level weighting at all, you can set all categories to equal weight or consolidate questions into a single category — that way a perfect score will cleanly equal 10