InfoPath 2010 running total sum in repeating table

Learn how you can use the sum function and preceding XPath axis in formulas to create a running total calculation in a repeating table on an InfoPath 2010 form.

You can use XPath axes such as for example preceding and preceding-sibling with functions in InfoPath to perform calculations. One such calculation is a running total in a repeating table, where the value of a field in a particular row of the repeating table is the cumulative value of the values of the fields in all of the rows preceding the current row.

The following InfoPath video shows you how you can use the sum function together with the preceding XPath axis within a formula for a rule or for the Default Value of a field in a repeating table control on an InfoPath form to perform a running total calculation within the repeating table and keep the values in the repeating table updated whenever a new row is added or whenever a value is changed within an existing field.

In this InfoPath 2010 tutorial video, you learned...

  • How to use the sum function with the preceding XPath axis in a formula.
  • How to set a field to recalculate itself.
  • How to set the Default Value of a field in a repeating table control on an InfoPath form.

See more InfoPath 2010 tutorial videos »

 
 Subscribe for updates via RSS or Email

Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners
InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013
InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners
InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010
InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers
InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services


Related InfoPath Articles:

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services