Conditional Logic: Total Column Not Summing Correctly in Input Table field.

Hello,

I am having a problem with some calculations in one of my forms.

I have short answer (number) questions and I am creating conditions to insert those answers into a table. Then, based on those entries I am using calculations to add or multiply numbers, of which the product will be entered into a field in the tables as well.

Here is an example of one of my tables that are not working. The TOTAL column (4) should be the sum of Column 2 and 3. The first line calculates correctly, but then the second line is not recognizing the $80.00 amount under Rainbow Air Price, and so the total showing is only column 2.

I have gone over and over checking my equations, and they are the same as line 1 so why is that part working and not the rest?

Here is my calculation for the total in Line 1:

And here is the total calculation for Line 2:

I'm going crazy trying to figure this out. Any suggestions??

Hi Tina,

Thanks for reaching out to Jotform Support. I cloned your form, tested it, and was able to recreate the issue, so I created a ticket and escalated this to our Developers. As a workaround, you can calculate the value on the second row's columns 2 and 3 on Input Table field labeled 2026 PACKAGE RATES - Rainbow Air by replacing the second row's column 3 with Number field labeled Adult FIT Package Rate on the 31st condition that has the issue on your form. You can clone my demo form or you can do it on your end. Let me show you how to do it:

1. In Form Builder, click on Settings on the orange navigation bar.
2. Click on the Conditions tab on the left part of the screen.
3. Scroll down, click on the Pencil icon on the 31st condition.

4. Scroll down, copy the settings on the condition.
5. Click on Save on the lower part of the screen.

Take a look at the screencast below to see my results:

That's it. We’ll update you as soon as we can.

Thank you, this worked!