Formula Ranking Table

You can use formulas to show your respondents how they scored in an assessment. Use the Formula Ranking Table to display the scores of your respondents on your quiz or surveys.

Enterprise ✓
ReportR ✓

You may have made a personality assessment, work-style assessment, or any other type of assessment and you want to give your respondents immediate feedback to show their strongest area. You can add the Formula Table variable to your final screen and have all the work done for you in an instant! Here's an example of how it could look:

formula ranking table example


In this help-guide we'll discuss the following:

  1. Set up a Formula Ranking Table
  2. What's next?

1 Set up a Formula Ranking Table

Using custom scoring to build a formula ranking table when each question is assessing a different category. Let's say you have an assessment measuring both IQ and EQ (Cognitive and Emotional Intelligence). We'll make an example of an assessment that has four questions. Q1 and Q2 measure IQ and Q3 and Q4 measure EQ. Now you want to set up a formula ranking table to show how respondents rate for IQ and EQ and which one is higher.

Once the assessment has been created, head over to the Extra Options screen and turn on Custom score

Formula ranking table - turn on custom score

Now you'll be able to give each answer a custom score. These scores will be used in the calculations of the formulas.

custom score for ranking table

Go through each of your questions and assign the score that you wish for the different answers.

Now it's time to create the formulas that will calculate the results of your respondent's answers. Find Formulas in the Extra Options tab.

add formula

In our assessment example of IQ and EQ, we need to create two formulas, one for IQ and one for EQ. As we mentioned, Q1 and Q2 are measuring IQ, so we want to take the custom score for the answers to each of those questions for the IQ formula. The EQ formula will add the custom scores of Q3 and Q4.

Formula table create formula

In the formulas section, here are the steps to follow to create your own formula with variables:

  1. Click Variables and select the custom scores you want to be counted for each score from the drop-down menu. In our example, we'll create the IQ formula by calculating *|q1_custom_score|*+*|q2_custom_score|*
  2. Create a formula for each score you want to calculate by repeating step 1. In our example, the EQ formula will be *|q3_custom_score|*+*|q4_custom_score|*
  3. Once you've created all the formulas you need, make sure to click apply to save all your changes

Now let's see how to include these formulas in the final screen where your respondents can view their score. Head right back to the Questions tab and scroll down to find Final screen. Type your text for the final screen and simply add the variable Formula Result Ranking Table which appears right at the bottom of the list of Variables. Adding this variable will make a table appear on the final screen showing the calculated results of all formulas listed with the highest score first.

Formula ranking table - add to final screen

It's a good idea to add some text underneath the variable to explain to the respondent how to understand the scores they will see. Just type your text in the Final message box once you've added the variable. Make sure to Save changes and you're done!

An alternative table you could add is the question block ranking table. This is very useful if you have a few question blocks and want to show your respondents in which area they scored the highest. 

2 What's next?

  • You can make the Formula Ranking Table appear in certain circumstances by setting up Question LogicQuestion logic allows you to specify which question to go to or go to the end of the questionnaire, based on the answer to a preceding question, quiz score, or contact data. Alternatively, you can decide to show or hide certain questions based on the criteria you set.
  • If you have a few question blocks and want to show your respondents in which area they scored the highest, you can use the Question Block Custom Score Table.

Make sure to Save changes and you're done!

Vincent is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.