How can I craate a sum of two tables

Hello Jotform team.

I want to integrate two tables, each containing a quote, into a single form. Each table has 10 rows with the following fields: Description, Units, Unit Cost, Total (excluding taxes), and Total (including taxes). At the end of the table, I've included a sum of the Total (excluding taxes) and Total (including taxes) fields.

I've managed to do this so far using a spreadsheet.

Now I need to sum the Total (excluding taxes) and Total (including taxes) fields from both tables. I've tried using the Form Calculation widget, but I haven't been able to do it.

How can I do this?

Thanks

-----------------------------------------

ESPAÑOL
Hola equipo de Jotform.

Quiero integrar en un formulario dos tablas sencillas de dos presupuesto. Son 10 filas por tabla con los siguientes campos: Descripción, unidades, coste unitario, total sin impuestos, total con impuestos. Al final de la tabla he incluido un sumatorio de los campos total sin impuestos y total con impuestos.

Hasta aquí lo he conseguido hacer con una Hoja de Cálculo.

Ahora necesito sumar los campos total sin impuestos y total con impuestos de las dos tablas. Lo he intentado con el Widget Calculo de Formulario pero no lo he conseguido.

¿como lo puedo hacer?

Gracias

Hi Francisco,

Thanks for reaching out to Jotform Support. I'm an AI assistant here to assist you.

Let me help you with summing the Total (excluding taxes) and Total (including taxes) fields from two tables in your form using the Form Calculation widget.

Here’s how to do it:

1. Add a Form Calculation widget to your form where you want to display the combined sum.
2. Open the widget settings by clicking the wand icon on the widget.
3. Use the Add Field button in the formula editor to add the sum fields from both tables. For example, if you have two calculation fields representing the totals of each table, add both of them in the formula editor separated by a plus sign (+).
4. Make sure the fields are set to number format (0-9) in the formula editor so their values are included in the calculation.
5. Save the widget settings. The widget will now show the sum of the totals from both tables.

If you have multiple calculation widgets for each table’s totals, you can add one more Form Calculation widget to sum those calculation widgets. You can hide this final widget if you don’t want it displayed.

This approach allows you to sum the Total (excluding taxes) and Total (including taxes) fields from both tables effectively within your form.

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