InfoPath Dev

Hi,

I have an InfoPath form with a repeating table and I am using the preceding sibling as one of the formulas. When a new row is inserted I want this formula to use the current amount and take it away from the previous amount above it, however the formula only takes away the first amount (first row in the table).

This is the formula I am using=      . - ../preceding-sibling::my:Main/my:AmountCertifiedForPayment[1]

I thought that by inserting the [1] it would use the previous amount.

Have you any suggestions on how to achieve this?

Thanks 

 You need to put the [1] on the preceding-sibling portion, not on the end:

../preceding-sibling::my:Main[1]/my:AmountCertifiedForPayment

The reason you were getting the first value instead of the one you wanted is a little tricky to explain, but putting a [1] after my:AccountCertifiedForPayment is definitely wrong, because it equates to "take the first my:AccountCertifiedForPayment under its respective parent" (and I assume each my:Main only has one my:AccountCertifiedForPayment each).