0 Replies Latest reply on Dec 6, 2012 3:15 PM by rbrooks63

    repeating subforms - counting to allow calculations to be repeated

    rbrooks63

      HI

      I am hoping someone can give me some advice.

      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!!

       

      Any help appreciated...