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


All times are GMT -4. The time now is 05:03 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.