Conditional Summation

Play the video

Subject: Conditional Summation
From: "Katie McNally" <kmcnally9@xxxxxxxxxxx>
Date: Wed, 01 Aug 2001 09:40:22 -0500

I am transforming XML to HTML. I am trying to sum up values. I need to display two totals. The first total is the Total Assets (amounts) for the primary borrower (Rank = 1). The second total is the Total Assets (amounts) for the secondary borrower (Rank = 2). What should my xsl look like in order to sum up the "Amount" values for the borrower with Rank = 1? (The same question would apply to summing the "Amount" values for borrower with Rank = 2).

I want to display:

Kelly Smith
Total Assets:  $1100

John Smith
Total Assets:  $400

A simplified version of my xml is:

<Loan>
<Borrower>
	<FirstName>Kelly</FirstName>
	<LastName>Smith</LastName>
	<Rank>1</Rank>
	<AssetSet>
		<Asset>
			<Amount>500</Amount>
		</Asset>
		<Asset>
			<Amount>600</Amount>
		</Asset>
	</AssetSet>
</Borrower>
<Borrower>
	<FirstName>John</FirstName>
	<LastName>Smith</LastName>
	<Rank>2</Rank>
	<AssetSet>
		<Asset>
			<Amount>100</Amount>
		</Asset>
		<Asset>
			<Amount>300</Amount>
		</Asset>
	</AssetSet>
</Borrower>
</Loan>

Thanks,
Katie


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list

Current Thread
Conditional Summation Katie McNally - Wed, 1 Aug 2001 10:44:52 -0400 (EDT) <= Michael Kay - Wed, 1 Aug 2001 12:16:58 -0400 (EDT) <Possible follow-ups> Oliver Becker - Wed, 1 Aug 2001 11:00:57 -0400 (EDT) Katie McNally - Wed, 1 Aug 2001 15:52:37 -0400 (EDT) Oliver Becker - Thu, 2 Aug 2001 05:01:32 -0400 (EDT)

<- Previous	Index	Next ->
Re: Swing-style Glue and Stru, Wendell Piez	Thread	RE: Conditional Summation, Michael Kay
Re: Question about Michael Ka, Perry Molendijk	Date	Re: Question about Michael Ka, Richard Draucker
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >