Option to sum column in submission table

Trying to sum a column in a submission table, but the option is not there.

Thanks!

Hi doug.r.shipley,

Thanks for reaching out to Jotform Support. Unfortunately, the Sum feature is not available for Form Calculation widget fields in Jotform Tables. As a workaround, you can use a Number field instead if you need to calculate a total within the table.

Alternatively, you can add a new column and use the Formula feature to perform calculations based on other fields. It's easy to do. Let me walk you through it:

1. On your Jotform Submissions Table, go to the end of the column and click the Add new column.

2. Select the Formula tab.

3. Click the Advanced Formula option.

4. Add the Total Due column in the Advanced Formula field by clicking it.

5. It should be like this after adding the Sum option.

Give it a try and let us know if you need help.