How to get total percentage from multiple choice answers

  • Profile Image
    Mariedyth
    Asked on March 14, 2019 at 05:15 PM

    I have a couple of questions on a form that has multiple choice answers in which the user needs to specify certain percentage(s) to each answer.  Does anyone have any idea on the best way of setting this up? Thanks in advance for your help!

    15525981051.png15525981172.png

  • Profile Image
    jonathan
    Answered on March 14, 2019 at 07:29 PM

    Please check on using Input Table field + Calculation

    How to Perform Form Calculation in the Matrix Field

    OR

    Using the Grading tool widget.

    1552605994zzz 2019-03-15 07.24.16.png


    I made a demo form you can test https://form.jotform.com/90727484222963

    Another one is the Slider with Calculated Result Widget

    The slider widget does not have input option, but it has slider thingy instead.

    Let us know how we can be of further help.


  • Profile Image
    Mariedyth
    Answered on March 14, 2019 at 07:47 PM

    Thank you so much, Jonathan! I am in awe at your prompt response and unparalleled customer service at Jotform. 

  • Profile Image
    Mariedyth
    Answered on March 14, 2019 at 08:48 PM

    Hi again, Jonathan,

    I'm a bit dense, so I was able to create the form calculation in the matrix field but how do I get the '%' in there the way you did? And is there any way I can limit the answers to not go over 100% total? 


    Here's the form: https://form.jotform.com/90725876053160

  • Profile Image
    jherwin
    Answered on March 15, 2019 at 12:22 AM

    You can do that in the condition section to get the value of each field in the input table.

    Here's a screencast you can follow:
    1552623669follow.gif

    Related Guide: How to Insert Text or Calculation into a Field Using Conditional Logic

    You can also use that to limit the value in each field.

  • Profile Image
    jherwin
    Answered on March 15, 2019 at 01:22 AM

    Sorry about that. Here's the slower screencast with an instruction: https://www.dropbox.com/s/f9fifas6l0zud2x/Screencast.mp4?dl=0

    You can also pause the video to make sure you're following the steps.

  • Profile Image
    Mariedyth
    Answered on March 15, 2019 at 01:27 AM

    Thank you so much for that! How do I get the '%' symbol into the 'Total Percentage'? like this sample? https://form.jotform.com/90727484222963

  • Profile Image
    diana
    Answered on March 15, 2019 at 03:32 AM

    You should add the '%' symbol into the calculation area.


    1552635025Screen Shot 2019-03-15 at 10.2

     

    I hope this helps!


    If you need any further assistance, please let us know.

  • Profile Image
    Mariedyth
    Answered on March 15, 2019 at 10:16 AM

    Hi Diana,

    Thanks for your quick response. I copied every (almost) element in your sample except for the 'brown square' I can't figure out how to do it but still, it doesn't work.

    1552659256calc.png



  • Profile Image
    BDAVID
    Answered on March 15, 2019 at 12:04 PM

    Add an opening parenthesis at the beginning and a closing parenthesis at the end:

    1552665785start.png

    1552665795end.png

    Result:

    1552665829result.png

    Let us know if you need more help.

  • Profile Image
    Mariedyth
    Answered on March 15, 2019 at 12:29 PM

    I'm sorry but it still does not work and I do not know what I am doing wrong. 1552667289open.png1552667325close.png

    https://form.jotform.com/90725876053160

  • Profile Image
    BDAVID
    Answered on March 15, 2019 at 01:51 PM

    It is not working because you have this condition:

    1552672099delete_001.png

    That condition is not needed, I have disabled that condition, so the calculation that shows the percentage sign works now in your form.

  • Profile Image
    Mariedyth
    Answered on March 15, 2019 at 02:12 PM

    BDavid, thanks you so much for figuring it out. I was given that condition instruction previously. I appreciate your help.

  • Profile Image
    jonathan
    Answered on March 15, 2019 at 02:50 PM

    I test your form and I can see now that the calculation with % symbol is now working properly.

    1552675176zzz 2019-03-16 02.38.43.png


    As you have found already, there is a limitation on how the calculation work if getting the max percentage to be at 100% only at all times.

    You cannot lock the result to be always at 100% similar to how the Slider with Calculated result work.

    But what you can do is give an alert to the user if the total % is still below or above 100%. You can do it using calculation Conditions feature.


    1552675793zzz 2019-03-16 02.49.24.png


    You can test it on my demo form https://www.jotform.com/90727484222963

    1552675852zzz 2019-03-16 02.50.17.png


  • Profile Image
    Mariedyth
    Answered on March 15, 2019 at 03:19 PM

    You guys at Jotform are awesome! Thank you so much!