RE: [xsl] newbie - problem with sum

Subject: RE: [xsl] newbie - problem with sum
From: "Andrew Welch" <andrew@xxxxxxxxxxxxxxxxxxxxxxx>
Date: Fri, 18 Jan 2002 11:47:54 -0000

So close... try this instead:

<xsl:variable name="sum" select="sum(/Report/Suspense/Amount[.>0])"/>

This will store/assign the sum of all values of the Amount element that are
greater than zero.  You can then access this number using $sum.  It works
like this:

sum() will sum all of the values of the nodes given to it

/Report/Suspense/Amount will match all Amount nodes that have a parent
Suspense that have a parent Report

[.>0] will filter the match to include only those nodes with values greater
than zero




-----Original Message-----
From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
[mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of Hesselberth,
Sent: Friday, January 18, 2002 11:06 AM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: [xsl] newbie - problem with sum

I need to sum all the Amounts with a value > 0
I set up a variable

<xsl:variable name="suspensecr">
	<xsl:for-each select="/Report/Suspense">
		<xsl:if test="Amount &gt; 0"><xsl:value-of

which seems to contain all the required values but I can't get a sum
produced from this.
I've tried all sorts of <xsl:value-of select="sum(.... but to no avail.
Can someone help please?

The information contained in this e-mail and any files transmitted with it
is private and confidential. It is intended for the named addressee only.
If you are not the intended addressee you are prohibited from
storing, copying or using the information in any way.
If you received this e-mail due to a transmission error please notify the
sender immediately. No liability is accepted by Northern Rock
for any losses caused by viruses contracted during transit
over the Internet or present in any receiving system.
This e-mail is not intended to create legally binding commitments on
behalf of Northern Rock plc, nor do its contents reflect the corporate
views or policies of Northern Rock plc.

 XSL-List info and archive:

 XSL-List info and archive:

Current Thread