Scores that are derived, not just summed.
The calculated scoring model lets you build custom formulas over any computed score in the assessment — section totals, segmentation scores, even other formulas.
A formula, not a hidden spreadsheet.
Most assessment tools stop at addition. Ascent's calculated model treats a score as an expression tree: reference a section score, a segmentation score, or a fixed constant, then combine them with sums, averages, ratios, caps, and scaling — evaluated instantly whenever an answer changes upstream.
Because a formula can reference any other computed score — including another formula — you can build layered logic: a section-level calculated score feeding into an overall calculated score, without ever leaving the builder or exporting data.
Example formula
cap(
scale(
weightedAvg(
section:"leadership" × 2,
section:"delivery" × 1,
segmentation:"risk" × 1
), factor: 0.05
), min: 0, max: 5
)
A weighted average of two sections and a segmentation score, rebased onto a 0–5 scale, and capped so it can never leave that range.
Six operations. Build anything from them.
Reference any computed score, then combine with these building blocks.
Sum
Add together any set of computed scores — sections, segmentations, or other formulas — into one total.
Average / weighted average
Blend scores evenly, or assign each one its own weight so certain sections or themes count for more.
Ratio
Divide one computed score by another — a completion rate, a pass ratio, a per-item average — safely returning zero rather than an error on an empty denominator.
Cap
Clamp a result to a floor and/or ceiling, so a derived score can never report above 100% or below zero no matter what feeds it.
Scale
Multiply a result by a fixed factor — rebasing a formula onto a 0–5, 0–10, or any custom scale your framework expects.
Reference
Pull in any question, sub-section, section, segmentation, or overall score by reference — the formula stays in sync as the assessment structure evolves.
Where calculated scores earn their keep
Executive summary score
A single top-line number built as a weighted average of every section score, plus a segmentation score, so leadership sees one figure that reflects the whole framework — not just a flat overall.
Pass-rate and ratio metrics
A ratio formula dividing 'sections above threshold' by 'total sections' produces a clean percentage metric for a report tile, without touching a spreadsheet.
Rebased and capped scores
Take a raw weighted sum, scale it onto your organization's familiar 0–5 rating scale, then cap it so a bonus-weighted section can never push the result out of range.
Formulas that reference formulas
A calculated score can itself be an input to another calculated score — build a small tree of formulas for multi-stage scoring logic without leaving the assessment builder.
Your scoring logic, exactly as designed.
Pair calculations with the rest of the scoring engine to build a framework that matches your methodology exactly.