Hi Guys,

Im trying to add up all the values (see example)

<xml>
<site>
   <value></value>
   <value></value>
   .
   .
   .
   .
<site>
<xml>

The problem was in a given xml. The value node could have many instance or could change the number of node.

And in my xslt

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

{... what's next to add up instance of value node}

</xsl:for-each>;)

Writing Software Application is just setting instructions to the code and there is nothing impossible.

Just use

<xsl:value-of select="sum(value)"/>

with site as the context node

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thnx Dude,

MORE POWER to this Forum!!!

Writing Software Application is just setting instructions to the code and there is nothing impossible.

Hi Michael,

Just wondering why it doesnt add up all the values.

sample xml:

<xml>
<site>
   <value>1</value>
   <value>2</value>
   .
   .
   .
   .
<site>
<xml>

sample xsl:

         <xsl:for-each select="site/value">
        <xsl:value-of select="sum(.)"/>
     </xsl:for-each>

Output:

         12......





Writing Software Application is just setting instructions to the code and there is nothing impossible.

sum() is a function that takes as input a set of nodes containing numeric values, and it produces as output the sum of these values. "." is a node-set containing a single node, and the sum of a set of numbers in which there is only one number is that number. So sum(.) means the same as number(.).

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thnx, I appreciate your help.

:D

Writing Software Application is just setting instructions to the code and there is nothing impossible.

Hi
   I need to add all the values like this
<root>
  <profile>
     <name>xyz<name>
     <salary>40000<salary>
     <addr>abc</addr>
 </profile>
 <profile>
    <name>mno<name
    <salary>50000<salary>
    <addr>def</addr>
  </profile>
</root>

I tried to get Total salary as 90000 but i am getting 4000050000

using
           <xsl:for-each select="root/profile/salary">
        <xsl:value-of select="sum(.)"/>
      </xsl:for-each>

The function sum() expects a node-set as its argument. You are supplying a single node (.), so sum() returns the numeric value of that node. You are then doing a string-concatenation of the results of several calls on the sum function.

You want <xsl:value-of select="sum(root/profile/salary)"/>



Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Hi mhkay

   Thanks alot, i am looking for a solution from hours. quick response with correct solution :)

Hi

  I need the continuation for the above solution. now i got the sum of all the salaries. now i can able to display in jsp. but i need to store that value in one jsp varible.

 i have one confirmation button. when the user clicks on that i have to display the total salary along with the confirmation message. how i can pass that value to javascipt method.