Complex Matrix Calcualtion

  • dsawant
    Asked 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?

  • Kevin Support Team Lead
    Replied on August 30, 2016 at 12:25 PM

    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. 

    Thanks.