Sum columns in vertical repeating table - InfoPath Dev
in

InfoPath Dev

Sum columns in vertical repeating table

Last post 03-25-2013 04:11 AM by acidcircus. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 03-19-2013 04:02 AM

    Sum columns in vertical repeating table

    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!
  • 03-22-2013 03:45 PM In reply to

     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.

    Hilary Stoupa

  • 03-25-2013 04:11 AM In reply to

    Re: Sum columns in vertical repeating table

    Thanks Hilary, I must have been over thinking it when the solution was so simple!
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.