I have a repeating vertical table within an InfoPath 2003 form which contains two columns; a user enters whole numbers into these columns which are then totalled in a third column. Using default values I have pre-populated a few rows in this repeating table.
The problem arises when the user can select an option to remove the second value column, I can't get the total in all rows of the repeating table to revert back to the appropriate first column value, instead it will display the first repeating column one value. I don't know if I can achieve this with rules, I am not sure I can iterate through the repeating nodes. I would need an 'if' option for a default value formula in the total column.
I have attached a template which should hopefully make things clearer, any help appreciated!