Summing cells in the footer row of a table object

[AnythingCounts-]

I try to sum the values of a column and display it in the footer row but not success it. Any advice?

I've tried adding the rows individually "cell2[0]+cell2[1]+cell2[2]" and I tried summing the "sum(cell2[*])"

[Srini_Dhulipall]

Try some thing like this..

You need to set all the Rows in your table have the same name. That can help reduce the coding..

Then place the below line of code in the Calculate event of the field where you want to display the calculated value. Set the language to FormCalc.

     Sum(Table1.Row1[*].Cell2);

I have a Table1 in my form and then added 3 rows with the same name. and then all of the rows have the same field "Cell2"..

Thanks

Srini

[AnythingCounts-]

All of my cells do have the same name. I used your code but it only does it for row1...I have 3 rows, how do I get it to calculate all the cells in that column?

[Srini_Dhulipall]

Can you send the form to LiveCycle9@gmail.com so I can ahve a look at it..

Thanks

Srini

[Srini_Dhulipall · Accepted solution]

Here is the updated file..

https://acrobat.com/#d=czb6OFGhZF5eJXYHKy0QjQ

The changes I did were..

     1) Renamed all the rows so they all have the same name "Row1".

     2) In the calculate event I changed the code a little so it looks like this.

               sum(Table2.Row1[*].Cell4);

Let me know if you have any issues..

Thanks

Srini

[AnythingCounts-]

I'm sorry but I am not seeing the file

[AnythingCounts-]

Thanks alot!!!