I have a complex table which has Totals going across the 12 monthly columns (eg July - Jun) and also has Total going down the rows (eg Total Income).
The formula that I have used for adding the the amounts across the colums is sum(Table20.Row2.Cell[*]) I have renamed majority of the cells to just 'Cell'. This works perfectly! My rows are number 1 - 43.
I now have an issue with the formula for adding the amounts going down each row. I used
.Row2.Cell,Row3.Cell,Row4.Cell,Row5.Cell,Row6.Cell,Row8.Cell,Row9.Cell,Row10.Cell,Row11.Cell,Row12.Cell,Row13.Cell) in the first cell and it worked perfectly but when I copied across to the other row cells, they all put the same amount in.
I understand why this has happened, all the cells and named 'Cell' but I don't know if there is an easier way.
Assistance would be greatly appeciated.
I have attached a calculation table sample that demonstrates my generic approach. The PDF looks like this...
I create 1 body row named 'row' with 13 columns. I then change the columns from text objects to numeric field objects and rename the objects 'jan', 'feb', 'mar',...and 'total'. I then declare any other properties I want to apply such as paragraph alignment. Once I am satisfied the 1 row satisfies my requirememts I then use the Copy Multiple toolbar feature to replicate as many rows as I need.
I then apply the same approach to the footer row. Each cell in the footer row becomes a column total. For each column total it easy to apply a FormCalc to each month. For example,
// form1.page1.subform1.table.footer.jan_::calculate - (FormCalc, client)
$ = Sum(table.row[*].jan)
For the row totals you need simply to add the column variables. FormCalc is smart enough to limit the scope to the current row.
// form1.page1.subform1.table.row.total::calculate - (FormCalc, client)
$ = jan + feb + mar + apr + may + jun + jul + aug + sep + oct + nov + dec