I need to repeat a flowed subform, which has a dynamic (growing) table in it (grows using add row button). In that table, there is a calculation (summing a column).
That sum is then used in another table lower in the same subform, in a couple of places (dividing the sum by a number, subtracting the sum from another numbered entered separately)
My problem is that when the second copy of the subform is made, the sumis always the same - I know this has something to do with needing to count the times the subform is created and then using some kind of Var function to make the sum change with each iteration of the subform. I just don't know how to do it!!