Available for plans: Free, Team, Business

Available for roles: Admin, Owner

In this article:

  1. Calculating the Criterion score.

  2. Calculating the Total score.

  3. How to access the board formula settings.

  4. Choosing board formulas.

The board formula is used to calculate the Total Score on the Top Priorities page. The calculation comprises two parts:

Calculating the Criterion score.


The initial part of calculating the total score involves calculating the criterion score of each criterion in your prioritization framework. There are two methods that you can use to get the criterion score:

  1. Criterion Score Sum.

  2. Average Criterion Score.

1. Criterion Score Sum.


The criterion score sum is calculated as a sum of all scores multiplied by the criterion weight.

We can express the formula this way:

Criterion Score (Cx) is the Sum of Scores (∑Sn) multiplied by the Criterion Weight (Wx).

Criterion Score (Cx) is the Sum of Scores (∑Sn) multiplied by the Criterion Weight (Wx)

So we calculate:

Criterion X Score = (Score 1 + Score 2 + Score 3 + Score n) * Weight X

For example:

3 users evaluated 2 criteria—Sales and Effort.

The criterion Sales has weight +3 and scores: 2; 3; 2.

The criterion Effort has weight -2 and scores: 0; 2; 1.

Sales Score Sum = (2 + 3 + 2) * 3 = 21

Effort Score Sum = (0 + 2 + 1) * -2 = -6

2. Average criterion score.


To get the average criterion score, we add up all the scores and divide the sum by their total number of scores, then we multiply the resulting figure by the criterion weight.

We can express the formula this way:

Average Criterion Score (ACx) is the Sum of Scores (∑Sn) divided by the Number of Scores (NS) and multiplied by the Criterion Weight (Wx).

Average Criterion Score (ACx) is the Sum of Scores (∑Sn) divided by the Number of Scores (NS) and multiplied by the Criterion Weight (Wx)


So we calculate:

Criterion X Average Score = ((Score 1 + Score 2 + Score 3 + Score n) / N Scores) * Weight X

For example:

3 users evaluated 2 criteria—Sales and Effort.

The criterion Sales has weight +3 and scores: 2; 3; 2.

The criterion Effort has weight -2 and scores: 0; 2; 1.

Sales Average Score = ((2 + 3 + 2) / 3) * 3 = 7

Effort Average Score = ((0 + 2 + 1) / 3) * -2 = -2

Calculating the Total score.


The second and final part involves calculating the total score. It is calculated using the criterion scores you found in the initial part. There are three methods you can use to calculate the total score:

  1. Sum of value criteria and effort criteria.

  2. Product of value criteria divided by product of effort criteria.

  3. Sum of value criteria divided by sum of effort criteria.

1. Sum of Value Criteria and Effort Criteria.


To get the total score, you add the criterion score sums, or the average criterion scores, of value criteria and effort criteria.

We can express the formula this way:

Total Score (TS) = the Sum of Criterion scores (∑Cn)

OR

Total Score (TS) = the Sum of Average Criterion Scores (∑ACn)

So we calculate:

Criterion Score Sum = (Score 1 + Score 2 + Score 3 + Score n) * Weight X

Total Score = Criterion A score + Criterion B score + Criterion X score

OR

Criterion X Average Score = ((Score 1 + Score 2 + Score 3 + Score n) / N Scores) * Weight X

Total Score = Criterion A average score + Criterion B average score + Criterion X average score

For example:

3 users evaluated 2 criteria—Sales and Effort.

The criterion Sales has weight +3 and scores: 2; 3; 2.

The criterion Effort has weight -2 and scores: 0; 2; 1.

Criterion score sum:

Sales Sum Score = (2 + 3 + 2) * 3 = 21

Effort Sum Score = (0 + 2 + 1) * -2 = -6

Total Score = Sales 21 + Effort -6 = 15

OR

Average criterion scores:

Sales Score Sum = ((2 + 3 + 2) / 3) * 3 = 7

Effort Score Sum = ((0 + 2 + 1) / 3) * -2 = -2

Total Score = Sales 7 + Effort -2 = 5

2. Product of value criteria divided by product of effort criteria.


This method involves multiplying all average scores of value criteria, then dividing the result by the product of all average scores of effort criteria.

Note: Don't use negative weights for Effort criteria.

The formula allows you to set up the original RICE scoring.

We can express the formula this way:

Total Score (TS) = the product of Average scores of Value Criteria (ACval) divided by the product of Average scores of Effort Criterion (ACeff);

So we calculate:

Criterion X Average Score = ((Score 1 + Score 2 + Score 3 + Score n) / N Scores) * Weight X

Total Score = (Criterion A Average Score (val) * Criterion B Average Score (val) * Criterion C Average Score (val)) / (Criterion D Average Score (eff) * Criterion E Average Score (eff)).

For example:

3 users evaluated 4 criteria—Reach, Impact, Confidence, and Effort.

The criterion Reach is Value, weight +1 and has scores: 500; 700; 300.

The criterion Impact is Value, weight +0.1 and has scores: 3; 1; 5.

The criterion Confidence is Value, weight +0.25 and has scores: 80%; 95%; 65%.

The criterion Effort is Effort, weight +0.5 and has scores: 5; 2; 8.

Average criterion score:

Reach (val) Score = ((500 + 700 + 300) * 1) / 3 = 500

Impact (val) Score = ((3 + 1 + 5) * 0.1) / 3 = 0.7

Confidence (val) Score = (((80 + 95 + 65) * 0.25) / 3) / 100 = 0.2

Note! When you use percents as scores, the average score is divided by 100.

Effort (eff) Score = ((5 + 2 + 8) * 0.5) / 3 = 2.5

Total Score = (Reach (val) 500 * Impact (val) 0.7 * Confidence (val) 0.2) / Effort (eff) 2.5 = / 5 = 5.6

3. Sum of value criteria divided by sum of effort criteria.


This method involves adding all average scores of value criteria, then dividing the result by the sum of all average scores of effort criteria.

Note: Don't use negative weights for Effort criteria.

The formula allows you to set up the original WSJF framework.

We can express the formula this way:

Total Score (TS) = the sum of Average scores of Value Criteria (∑ACval) divided by the sum of Average scores of Effort Criterion (∑ACeff);

So we calculate:

Criterion X Average Score = ((Score 1 + Score 2 + Score 3 + Score n) / N Scores) * Weight X

Total Score = (Criterion A Average Score (val) + Criterion B Average Score (val) + Criterion C Average Score (val)) / (Criterion D Average Score (eff) +Criterion E Average Score (eff)).

For example:

3 users evaluated 4 criteria—User Value, Time Criticality, Risk Reduction, and Job Size.

The criterion User Value is Value, weight +2 and has scores: 8; 13; 20.

The criterion Time Criticality is Value, weight +1 and has scores: 3; 1; 5.

The criterion Risk Reduction is Value, weight +1.5 and has scores: 13; 5; 5.

The criterion Job Size is Effort, weight +0.5 and has scores: 5; 2; 8.

Average criterion score:

User Value (val) Score = ((8 + 13 + 20) * 1.25) / 3 = 17.1

Time Criticality (val) Score = ((3 + 1 + 5) * 1) / 3 = 3

Risk Reduction (val) Score = ((13 + 5 + 5) * 1.5) / 3 = 11.5

Job Size (eff) Score = ((5 + 2 + 8) * 0.5) / 3 = 2.5

Total Score = (User Value (val) 17.1 + Time Criticality (val) 3 + Risk Reduction (val) 11.5) / Effort (eff) 2.5 = 31.6 /2.5 = 12.64

How to access the board formula settings.


  1. Inside a board, go to Criteria and Total Score Settings.

  2. Find the Total score formula at the bottom of the criteria settings page, click on it to access the total score settings page.

Choosing board formulas.


If you choose the Criterion Score Sum formula to calculate the criterion score, then to calculate the total score you can only use the Sum of Value Criteria and Effort Criteria formula.

Note: the total score depends on the number of people who evaluated the issue.

On the other hand, if you pick the Average Criterion Score formula to calculate the criterion score, then to calculate the total score you can use any of the three formulas for calculating the total score.

You can play with the formulas and see changes of your priority rankings in real-time, to come up with a set of formulas that work best for you.

At the bottom of total score formula settings window, you can find hints of how the formulas you choose work.


If you have any questions, please contact us in the chat bottom right corner.

Did this answer your question?