Table Column Calculations

[Dennis5E2F]

I have a table in Acrobat 2017 form.  There are 2 columns for payments to utility vendors.  One for Gas One for Electric.  What I am trying to do is total each column then sum the 2 column totals.  I can create calculations  for the 2 columns alright then sum the 2 totals, but it doesn't work like I want it to.  The first column imports payments from our database, the second column payments have to be entered by our caseworkers.  The data imports fine into tcolumn 1 of the table but does not calculate until I enter an amount in the second column then all of the calculations happen.  If nothing is entered into the 2nd column no calculations happen so if the caseworker doesn't have a payment for column 2 all of the totals stay zero.  Can this operation be done with the "Value is the sum" calculation or will I have to use Java Script to get it to work like I want it.  I don't know how to write java script.  Thanks.

[try67]

The issue is not how the calculation happens, but the fact that importing data does not trigger the calculations.

If you're doing it with a script you can add a command to force a calculation after the import, or you could add a command to do it when the file is opened, or saved, etc.