JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Complex Matrix CalcualtionAsked by dsawant on August 30, 2016 at 10:35 AM
Hi I have created a matrix and given the following values to the options.
1 - Strongly Agree, 2 - Somewhat Agree, ... 8 - Don't Know
There are 8 questions on the form.
I needed to do a calculation somewhat 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 whichever is the minimum of value1, value2, value3 and value4 I needed to print an output on thankyou page.
If value1 is minimum print you are a master, if value2 is minimum print you are an apprentice etc etc..
Is this possible to do using JotForm?
I can see you have already opened another thread similar to this, here is the link: https://www.jotform.com/answers/920219
Please check that thread, we will assist you on that thread as soon as possible.