View Entire Topic

MinusZero

01-01-2019

Hi JainSa,

If your rows are fixed you can simply add them up, but if you are dynamically adding rows, you can do this.

Assuming the first data entry row is repeating, in the total field at the bottom add this code.

form1.#subform[0].Table1.Row2.NumericField1::calculate - (FormCalc, client)

sum(Table1.Row1[*].NumericField1[*])

1658195_pastedImage_0.png

Whenever you create a new row ( i have repeated row1), a new instance will be created before the total row and the new totals will be displayed when the field is edited.

1658196_pastedImage_1.png