p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Infopath (http://p2p.wrox.com/forumdisplay.php?f=189)
-   -   Using preceding-sibling (http://p2p.wrox.com/showthread.php?t=70543)

mcanne98 September 11th, 2008 11:09 PM

Using preceding-sibling
 
Hi
Been stuck on using this formula...

(../../../my:OpeningBal | preceding-sibling::*[1]/ClosingTransBalance)[(count(preceding-sibling::*/TransID) = 1) + 1]

Let me explain...
it is an IF statement
the true result being ../../../my:OpeningBal
the false result being preceding-sibling::*[1]/ClosingTransBalance
i.e. it sets the value to the field ClosingTransBalance of the previous item in the Repeating table.

Condition: count(preceding-sibling::*/TransID) = 1
it counts whether there is ONE item in the items repeating table

Thanks
Ced



All times are GMT -4. The time now is 08:33 PM.

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.