View Single Post
  #1 (permalink)  
Old September 11th, 2008, 11:09 PM
mcanne98 mcanne98 is offline
Registered User
 
Join Date: Sep 2008
Location: AA, AA, Mauritius.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

Reply With Quote