Re: Calculate fields in repeating table rows with condition

rdoe777 — Mon, 03 Nov 2014 17:53:17 GMT

I think I was able to figure it out using method 2 in below post.

http://blogs.msdn.com/b/infopath/archive/2006/11/27/conditional-default-values.aspx

Calculate fields in repeating table rows with condition

rdoe777 — Mon, 03 Nov 2014 17:38:42 GMT

Hi,

I'm trying to come up with an XPath formula to calculate fields as in below repeating table in a web based form. The first row value for Balance field, $2000, needs to be populated from outside of the repeating table, but all values for subsequent rows for Balance field need to equal to "previousRowBalance - previousRowAmount", like the second row Balance value is $2000-$100=$1900.

Amount | Balance

$100 | $2000

$150 | $1900

$350 | $1750

Does anyone know how to do this? Thanks.

Newbie Questions

Re: Calculate fields in repeating table rows with condition

Calculate fields in repeating table rows with condition