How to Get total Score from my Column Values

  • Darryl Williams
    Asked on April 22, 2024 at 11:13 AM

    I'm having problems with trying to add my column values to produce a total score at the bottom of my form. I have watched the videos and tutorials but the calculation is off and is not adding the sum columns. Please help.

  • Kyle JotForm Support
    Replied on April 22, 2024 at 11:50 AM

    Hi Darryl,

    Thanks for reaching out to Jotform Support. I’m sorry you're having difficulties getting that feature to work. Can you send me the link to your form so I can take a look at it for you?

    Once we hear back from you, we'll be able to move forward with a solution.

  • outwardinlearning
    Replied on April 22, 2024 at 12:07 PM
  • Jemuel JotForm Support
    Replied on April 22, 2024 at 12:35 PM

    Hi Darryl,

    Thanks for getting back to us. When I cloned and tested your form, the same thing happened for me. After investigating further, I noticed that the other rows don't have values, and your calculation lacks a plus signs. Let me show you how to fix it:

    1. In Form Builder, click on your Input Table field.
    2. Click on the Gear icon, and select Options tab.
    3. Under Calculation Values, enter the value for each row. You can copy the calculation values as shown below. How to Get total Score from my Column Values Image 1 Screenshot 40
    4. Now, click on the Form Calculation widget, and then click on the Wand icon.
    5. Set up the form calculation as shown below.
    6. Lastly, click on Save. How to Get total Score from my Column Values Image 2 Screenshot 51

    Here's my result: How to Get total Score from my Column Values Image 3 Screenshot 62 Here's my demo form. You can clone it to test or inspect.

    Keep us updated and let us know if you need any more help.

 
Your Answer