# I have created a matrix with 6 questions and 8 option box as answers.

• dsawant
Asked on August 30, 2016 at 10:31 AM

I have assigned a value of 1 for "Strongly Agree", 2 for "Agree", and so on until an 8 to "Don't Know" etc..

I wanted to make a calculation like this -

value1 = |Opt1-1| + |Opt2-1| + |Opt3-1| + |Opt4-1| + |Opt5-1| + |Opt6-1| + |Opt7-1| + |Opt8-1|

value2 = |Opt1-2| + |Opt2-2| + |Opt3-2| + |Opt4-2| + |Opt5-2| + |Opt6-2| + |Opt7-2| + |Opt8-2|

value3 = |Opt1-3| + |Opt2-3| + |Opt3-3| + |Opt4-3| + |Opt5-3| + |Opt6-3| + |Opt7-3| + |Opt8-3|

value4 = |Opt1-4| + |Opt2-4| + |Opt3-4| + |Opt4-4| + |Opt5-4| + |Opt6-4| + |Opt7-4| + |Opt8-3|

and if value 1 is the minimum of these values I need to output on a thank you page that you are master,

if value 2 is the minimum then you are an apprentice etc..

How can I check which is the minimum of these values and give a certain output?

Is it possible to do using JotForm?

Thanks & Regards,

Digvijay

• BDAVID
Answered on August 30, 2016 at 01:53 PM

1) First, you need to assign values  to each option. As far as  I understand, in each row, columns options will go from 1 to 7(I see there are only 7 options).

Simply click on the gear icon of your matrix field>>Edit Properties>>Options>>Calculation Values, and enter each value:

VALUES TO BE ENTERED:

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

1,2,3,4,5,6,7

Example

2)Now  that you have the values for each option, you can perform the calculation as shown in this guide: https://www.jotform.com/help/343-How-to-Perform-Form-Calculation-in-the-Matrix-Field

According to this logic:

value1 = |Opt1-1| + |Opt2-1| + |Opt3-1| + |Opt4-1| + |Opt5-1| + |Opt6-1| + |Opt7-1| + |Opt8-1|

value2 = |Opt1-2| + |Opt2-2| + |Opt3-2| + |Opt4-2| + |Opt5-2| + |Opt6-2| + |Opt7-2| + |Opt8-2|

value3 = |Opt1-3| + |Opt2-3| + |Opt3-3| + |Opt4-3| + |Opt5-3| + |Opt6-3| + |Opt7-3| + |Opt8-3|

value4 = |Opt1-4| + |Opt2-4| + |Opt3-4| + |Opt4-4| + |Opt5-4| + |Opt6-4| + |Opt7-4| + |Opt8-3|

The calculation would be the following:

3) Clone this calculation field, and replace the discount value, example:

Result:

4) The last part would be checking which is the minimum of these values and give a certain output in the Thank You page.

You will need to create conditions to evaluate it, and forward to a custom Thank You page depending on which condition is met. Here is the guide that explains how this works: https://www.jotform.com/help/317-Change-Thank-you-URL-Based-on-a-Condition

The conditions would be as follow:

Here is my cloned version: https://form.jotform.com/62424822297964

Please clone it in your account as explain on this guide: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

I have created the conditions for you to simply add the URL of the corresponding Thank You page.

Let us know if you need more help.

• dsawant
Answered on August 30, 2016 at 08:33 PM

WOW!! Thanks @BDAVID. I am going to try this tonight.

I will definitely get back with you if I get stuck somewhere..

Thank you so much for putting in the time and the effort to give such a descriptive answer.

• liyam
Answered on August 31, 2016 at 02:36 AM

Hello dsawant,

On behalf of David, you are welcome. Feel free to let us know should you have further questions or if you have any other concerns.

Thanks.