SSDN - How to sum the values

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

Dink Lo

Subject: How to sum the values
Author: Dink Lo
Date: 31 Aug 2006 12:09 AM

Hi,

I have use XSLT to select some data I want like follows:

<xsl:for-each select="Datalist">
<xsl:value-of select="value"/>
</xsl:for-each>

If the xml is like follows:

<Datalist>
<value>100</value>
</Datalist>
<Datalist>
<value>200</value>
</Datalist>
<Datalist>
<value>300</value>
</Datalist>

The output will be 100200300.

Now I want to compute the sum of the value.
In this case, the sum will be 600.

In fact my case is more complicated.
I have some constraints to select the value and not all of the value will be selected. So plz don't ask me to use sum function.

Does anybody know how to do that?
Any suggestion will be appreciated.

Dink

Ivan Pedruzzi

Subject: How to sum the values
Author: Ivan Pedruzzi
Date: 31 Aug 2006 10:29 PM

It is difficult to help if you don't tell us what are those "constraints".

Are you aware that you can count node using a xpah expression including predicates?

For instance sum only value greater then 100

sum(Datalist/value[ number(.) > 100 ])

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.