How to get total percentage from multiple choice answers

  • Mariedyth
    Asked on March 14, 2019 at 5: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!

    How to get total percentage from multiple choice answers Image 10How to get total percentage from multiple choice answers Image 21

  • jonathan
    Replied on March 14, 2019 at 7: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 Screenshot 10


    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.


  • Mariedyth
    Replied on March 14, 2019 at 7:47 PM

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

  • Mariedyth
    Replied on March 14, 2019 at 8: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

  • jherwin
    Replied 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 Screenshot 10

    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.

  • Mariedyth
    Replied on March 15, 2019 at 12:53 AM

    Jherwin!!! You're teasing me. The screencast is way too fast. Anyway, I was able to that calculation but there are two things I am looking for:

     

    1) Have the '%' symbol on the final output similar to Jonathan's sample;

    2) Limit the total to 100%.

     

    TIA!

  • jherwin
    Replied on March 15, 2019 at 1: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.

  • Mariedyth
    Replied on March 15, 2019 at 1: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

  • diana
    Replied on March 15, 2019 at 3:32 AM

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


    1552635025Screen Shot 2019 03 15 at 10 Screenshot 10

     

    I hope this helps!


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

  • Mariedyth
    Replied 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 Screenshot 10



  • David JotForm Support Manager
    Replied on March 15, 2019 at 12:04 PM

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

    1552665785start Screenshot 10

    1552665795end Screenshot 21

    Result:

    1552665829result Screenshot 32

    Let us know if you need more help.

  • Mariedyth
    Replied 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 Screenshot 101552667325close Screenshot 21

    https://form.jotform.com/90725876053160

  • David JotForm Support Manager
    Replied on March 15, 2019 at 1:51 PM

    It is not working because you have this condition:

    1552672099delete 001 Screenshot 10

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

  • Mariedyth
    Replied on March 15, 2019 at 2:12 PM

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

  • jonathan
    Replied on March 15, 2019 at 2: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 Screenshot 10


    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 Screenshot 21


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

    1552675852zzz 2019 03 16 02 Screenshot 32


  • Mariedyth
    Replied on March 15, 2019 at 3:19 PM

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