I am trying to do some simple calculations in a table in Adobe LiveCycle Designer and I cannot figure out what I am doing wrong.
I have created a TABLE (Table 1), and can identify the names of the cells.
I am trying to add Row1.Cell3 and Row1.Cell4 together in a subtotal column-- which happens to be Row1.Cell5. I need to do that for several rows but can't get it to work for the first one.
Then, I need to add All the Row 5 subtotal values together. (Row1.Cell 5, Row2.Cell5, Row3.Cell5, etc.)
I have tried using the help system and the advice of another person who said to use:
sum(row1.cell3,row1.cell4)
He told me to use this instead of the suggested FormCalc forumla I found in help (which I also could not get to work) because I was using a table.
It doesn't work and gives me the message:
Error: Accessor 'row1.cell3' is unknown
I am stumped. Can anyone help me? It seems like it should be simple, but it hasn't been.
