add a column of numbers

I want to have a column on the bottom to total all of the $ amounts in the amount column

Hi Marci,

Thanks for reaching out to Jotform Support. Adding a single row or column in the Input Table element for a total is unsupported. When you add a row or column, this will be added after the last ones. As a workaround, you can use the Form Calculation widget to get the total of all the rows or columns. Doing this is easy, let's walk through this together using a cloned form:

1. In Form Builder, click on Add Element on the left side.
2. Under the Form Elements, go to the Widgets tab. Drag and drop the Form Calculation widget on the form's page after the Input Table element.
   
3. Now, click on the wand icon on the right side of the Form Calculation widget.
4. Type in a $ sign and add space.
5. Next is to click on the Add Field and select the Input Table element. Check the box of all the rows to add into the calculation field. Then add a plus sign after each row.
6. Finally, hit on the Save button.
   
   

Here's a screencast showing how the form works:

You’re all set. Let us know if you have any other questions.

it's rounding up, how can i be sure its exact?

Hi Marci,

I cloned your form and tested it to see if I could replicate the issue, but the total is not rounding up. Check out the screencast below to see my results:

Can you remove the Form Calculation widget again and re-add it and follow the guide provided by my colleague here?

Give it a try and let us know how it goes.

rounded to 3917

Hi Marci,

I have tested your form, but everything worked the way it was supposed to. Take a look at the screenshot below to see my results:

I have also checked the Form Calculation widget and can see that it's configured correctly. If you can send us a short screen recording of the steps you’re taking, it’ll help us pinpoint the issue. Loom, Google Drive, or Dropbox links all work fine.

Once we know more about what’s going on, we can figure out the fix.

try using my numbers as a test

Hi Marci,

Thanks for walking me through that. It’s much clearer now. To avoid the Form Calculation rounding off the result, you can set the Decimal Places to 2. Let me show you how:

1. In Form Builder, click on the Wand icon of the Form Calculation widget to open Settings.
2. Next, click on the Options just at the top of the Save button.
3. Check the Use commas for decimal point option.
4. Lastly, set the Decimal Places in Numerical Results to 2, then click on Save.

Here's the result:

Give it a try and let us know how it goes.