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.