Calculated Field Problem

[kkekic1]

I am designing an order form and this is my first time using livecycle. I have 2 tables each with 10 drop down boxes of varying items. Followed by a unit price, quantity and total.

All of these boxes work correctly.

I am having problems calculating the total at the bottom for all the boxes.

I have tried

Sum(Table1.Row1.tptw1, Table1.Row2.tptw2); and so on. I get an error accessor in unknown

I have tried to make a hidden columnm, however I cannot get it to remain totally invisible.

I am know basically nothing about javascript which I am sure is what is needed.

Any help would be great

[whyisthisme]

You can use FormCalc instead of Javascript and either do:

$ = Table1.Row1.tptw1 + Table1.Row2.tptw2 + etc

or you can name all the rows and the cells with the number the same thing (ie. call them all Row1 and then it will automatically make it Row1[0], Row1[1], etc and do the same with the cell) and them just do

$ = Sum(Row1[*].tptw)