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
