Greetings-

I am formatting a receipt-style page, and want to do a sum by attribute. The XML looks like this:

<?xml-stylesheet type="text/xsl" href="style.xsl"?>
<report>
    <entity>
            <row>
                <item thename="product1" theval="100"></some_value>
                <item thename="product2" theval="200"></some_value>
                <item thename="product1" theval="1"></some_value>
                <item thename="product2" theval="4"></some_value>
                <item thename="product2" theval="5"></some_value>
            </row>
    </entity>
</report>

and I would like the output to look like this:

product1: 101
product2: 209

Can you help me with the style.xsl?

Thanks in advance.

XSL is NOT a scripting language so has no mathematical capabilities

XSLT does allow some basic mathes in the "value-of" attribute.

Originally Posted by badams

XSLT does allow some basic mathes in the "value-of" attribute.

That is not mathematics, it is a method of selecting elements according to an attribute value.

XSL cannot ADD the value of those attributes to a running total.

XML

<?xml-stylesheet type="text/xsl" href="style.xsl"?>
<report>
    <entity>
            <row>
                <item thename="product1" theval="100"></item>
                <item thename="product2" theval="200"></item>
                <item thename="product1" theval="1"></item>
                <item thename="product2" theval="4"></item>
                <item thename="product2" theval="5"></item>
            </row>
    </entity>
</report>

XSL

<xsl:stylesheet version="1.0" 
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
    
    <xsl:template match="report">
        product1: <xsl:value-of select="sum(entity/row/item[@thename='product1']/@theval)"/>
        product2: <xsl:value-of select="sum(entity/row/item[@thename='product2']/@theval)"/>
    </xsl:template>
    
</xsl:stylesheet>

OUTPUT
product1: 101
product2: 209

Good point!

Using XPath expressions.

Thanks, everybody, for your help. Voxink, that returns exactly what I asked for!

I've been toying with for-each to try to get this to be dynamic. That is, if I apply this stylesheet to another XML document with 4 products, it will display the sum of each of the 4 products.

It seems that this works so far:

<xsl:stylesheet version="1.0" 
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
	<xsl:template match="report">	
		<xsl:for-each select="entity/row/item/@thename[not(.=preceding::item/@thename)]">
			<xsl:value-of select="current()"/>=
			<xsl:value-of select="sum(/report/entity/row/item[@thename=current()]/@theval)"/><br />
		</xsl:for-each>
	</xsl:template>
</xsl:stylesheet>

Again, thanks for your help! It was a huge push in the right direction. Without it, I would still be sleeping through the tutorial lessons online.