The total is not calculating correctly

  • Profile Image
    News127
    Asked on September 15, 2020 at 09:36 PM

    I have a 5 question quiz, multiple choice, 2 answers for each. I don't seem to be able to get it to give me a tally of the correct responses. I gave the correct response a value of 1 and the incorrect response a value of 0.

  • Profile Image
    roneet
    Answered on September 16, 2020 at 12:06 AM

    I see that there is only 4 option added to the total score:

    1600229173_5f618f358eeb8_undefined

    Please add the 5th question too.

    I hope this will solve the issue.

    Thanks.

  • Profile Image
    News127
    Answered on September 16, 2020 at 09:13 AM

    Added 5th question, but still does not sum correct responses properly.

  • Profile Image
    Patrick_R
    Answered on September 16, 2020 at 10:37 AM

    Hello! I just checked your Form and didn't find any issues with it. I selected the following combination and the Score value that I received was 5 which seems to be correct as per set Calculation Values for the Single Option fields values (screenshot attached below for your reference).

    1600266972_5f6222dcadceb_chrome-capture

    1600266993_5f6222f10d6f6_chrome-capture

    Q) May we know for which value combination you're getting an incorrect value?

    Awaiting your response.

  • Profile Image
    News127
    Answered on September 16, 2020 at 01:56 PM

    I am not getting a score on my spreadsheet for each submission. I set up a new practice document with what I thought were the same settings and no score is showing after entry is submitted.  HELP! https://form.jotform.com/202594591720962

    Does it matter when the "correct" answers are scored? This is being used as a contest form and the correct answers will not be known until after all the submissions have been made.

  • Profile Image
    Jimmy_D
    Answered on September 16, 2020 at 04:27 PM

    I Can see the scores on your submissions page. Form respondent will not know their score because the field is hidden on the form.

    1600287909_5f6274a57794b_undefined

    Feel free to let us know if I failed to answer your question.

    Regards,

  • Profile Image
    News127
    Answered on September 17, 2020 at 11:31 PM

    Look at the spreadsheet for https://www.jotform.com/sheets/202594591720962 and tell me why it isn't showing the total of the correct answers? I have to enter the correct answers after all the contest forms have been completed.


  • Profile Image
    ashwin_d
    Answered on September 18, 2020 at 03:03 AM

    I did check your form and found that the calculation formula you have added in form calculation widget is not correct. Please check the screenshot below:

    1600412323_5f645aa3c8cfb_formCalculation

    I have fixed this issue in your form's calculation widget. Please test your form and see if the calculation is working as expected.

    Do get back to us if you have any questions. (I have not added "DOMINOS TIEBREAK QUESTION" in the calculation. Go ahead and add it in form calculation widget if you need the value to be added in calculation).

  • Profile Image
    News127
    Answered on September 18, 2020 at 03:02 PM

    The values (1 for the winning team and keep the 0 for the losing team) have to be entered after all the forms have been submitted. I put zeroes in for both teams initially, resulting in a score of 0. I went back in and changed the first 3 or 4 values of who the winning team might be and the score does not change although a couple of the teams selected now have a value of one.

    It appears the "correct" answers must be placed in before the submissions are received to be scored? It will tabulate scores if I put the values in prior to sending in a submission, but the contest can't work that way.

  • Profile Image
    Jimmy_D
    Answered on September 18, 2020 at 04:23 PM

    Yes, correct. Unfortunately, the calculation only works on the form, not on the submissions page.

    Let us know if you have more questions.

    Best,

  • Profile Image
    News127
    Answered on September 18, 2020 at 08:47 PM

    Thanks for the answer Jimmy_D. Wasn't the one I wanted, but at least I know I was trying to make something happen jotform isn't designed to do. Would be a great feature for contest platform if the values could be added post submission. Thanks again

  • Profile Image
    roneet
    Answered on September 18, 2020 at 10:25 PM

    Do you want to change the score of the questions every time? Do you want to compare the score obtained?

    May we know in detail how you would like to see your survey form? Could you please brief us on your requirement?

    Looking forward to your response.

    Thanks.

  • Profile Image
    News127
    Answered on September 19, 2020 at 10:56 PM

    We are using the form in a contest where the correct answer will not be known until AFTER all the submissions have been received for that week. Until the submission deadline passes, we need to have both answers value=0. Once we know the correct answer after the submission deadline then we want to give the correct response a value=1. We had hoped the submissions spreadsheet score column would then have the correct number of answers for each participant.

    The form works the way we need it to with the exception of being able to get a submission score by substituting a value=1 for 0 on what we know is the correct response after the deadline.

    That would allow us to simply compare scores instead of having to tally correct responses from each submission.

  • Profile Image
    Vanessa_T
    Answered on September 20, 2020 at 12:12 AM

    Generally, a feature request may be granted if the feature is applicable/useable by the majority of our users.

    Reviewing your form, it seems that your asking like a prediction on who's gonna win next week. Then when you already know who exactly won, you'd like to know who among your respondents have correctly guessed the most.

    What you want can only be done by editing the calculation values of each field, then manually editing each submission so that the total will be calculated.


  • Profile Image
    News127
    Answered on September 20, 2020 at 08:57 AM

    That is what I thought and is not something I would do with the number of submissions expected. I'll simply visually count the number of correct responses on each submission. At least the spreadsheet makes it easier than having to check each email separately. Thank you.

  • Profile Image
    Yvette_L
    Answered on September 20, 2020 at 09:40 AM

    Thank you for your response.

    Please let us know in the future if you have any more queries, thank you!

  • Profile Image
    Yvette_L
    Answered on September 20, 2020 at 09:40 AM

    Thank you for your response.

    Please let us know in the future if you have any more queries, thank you!