Use our Google Custom Search for best site search results.
I have a form with a repeating section, and certain fields in the section get added to a subtotal outside the section. My question is, when a person deletes a section how do I subtract the amount in the repeating section from the subtotal?
By the way, this InfoPath for submits to SP2007. So I don't think I can enable any code. I've had problems with that before.
Use a calculated value for your total that uses the xpath command "sum(group)" where group is the repeating group node in your data source corresponding to the repeating section (the one with the little blue thing on it). Note that calculated values are called expression boxes in InfoPath 2007.
Ok thanks! I will look into that. Also I have a field with number of instances so that I can calculate an average. Maybe I can use the same method but use count(group) instead.
Thanks Patrick, don't know why I hadn't thought of that! It works now!