Re: Preceding Sibling

Jimmy — Mon, 21 Apr 2014 15:27:59 GMT

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).

Preceding Sibling

Shannan — Thu, 17 Apr 2014 11:34:19 GMT

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

General

Re: Preceding Sibling

Preceding Sibling