General

Re: Sum columns in vertical repeating table

acidcircus — Mon, 25 Mar 2013 11:11:58 GMT

Thanks Hilary, I must have been over thinking it when the solution was so simple!

Re: Sum columns in vertical repeating table

Hilary Stoupa — Fri, 22 Mar 2013 22:45:19 GMT

Hi - use a default value for the total column instead of using rules to set it. If your option gets set to false, clear the values in column 2 - I'm attaching your sample w/ these changes. Save the file locally, right click and select design to see the changes / preview.

Sum columns in vertical repeating table

acidcircus — Tue, 19 Mar 2013 11:02:08 GMT

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!