xsl-list
[Top] [All Lists]

Re: [xsl] Problem with filtrate sum

2009-10-01 13:40:11
Thanks that's what I mean

2009/10/1 Martin Honnen <Martin(_dot_)Honnen(_at_)gmx(_dot_)de>:
j23 wrote:

       <xsl:template match="root-element">

               <table>
                       <xsl:variable name="x">
                               <xsl:for-each select="Row[position()>=1]">
                                       <d><xsl:value-of
select="translate(Number,'.','')"/></d>
                               </xsl:for-each>
                       </xsl:variable>

                       <td><xsl:value-of select="sum(exslt:node-set($x)/d)
"/></td>

               </table>
       </xsl:template>

</xsl:stylesheet>

I would  like to sum number (without character '.'). It works.
Now I try sum  for one name, I make like this but it doesn't work
<xsl:value-of select="sum([Name = 'Joe']exslt:node-set($x)/d) "/>
How can I filtrate sum with using function translate, or key?

If it is just for one name then you can simply change the code that sets up
the variable e.g.

                       <xsl:variable name="x">
                               <xsl:for-each select="Row[position()>=1][Name
= 'Joe']">
                                       <d><xsl:value-of
select="translate(Number,'.','')"/></d>
                               </xsl:for-each>
                       </xsl:variable>

then you would simply compute the sum as before
 <xsl:value-of select="sum(exslt:node-set($x)/d)"/>

If you want to compute the sum for several names then you need to store the
name when you build your variable e.g.

                       <xsl:variable name="x">
                               <xsl:for-each select="Row[position()>=1]">
                                       <d>
 <name><xsl:value-of select="Name"/></name>
 <value><xsl:value-of select="translate(Number,'.','')"/></value>
</d>
                               </xsl:for-each>
                       </xsl:variable>

Now you can compute e.g.

 <xsl:value-of select="sum(exslt:node-set($x)/d[name = 'Joe']/value)"/>

--

       Martin Honnen
       http://msmvps.com/blogs/martin_honnen/

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>