RE: RE: [xsl] Setting values for variable

["john lee" <excel_man@xxxxxxxxxxx>]

Thanks for all the replies.
This is my situation:

<Trade>
<Record>
<Account>R</Account>
<Payment>10000</Payment>
<Balance>50000</Balance>
</Record>
<Record>
<Account>R</Account>
<Balance>40000</Balance>
</Record>
<Record>
<Account>I</Account>
<Payment>5000</Payment>
<Balance>50000</Balance>
</Record>
<Record>
<Account>I</Account>
<Balance>50000</Balance>
</Record>
</Trade>

I need to run the total based on the account Type. If there is <Payment> Tag 
coming back, I'll calculate the total based on the payment, but if there 
isnt, I will substitute the amount with 2% of the value in the <Balance>. So 
I need to go into all the Record, look to see if there is Payment tag coming 
back. If yes, use it. If no, use 2% of the Balance value.
Anybody can help me with this problem ?

Thanks

_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* 
http://join.msn.com/?page=features/virus