Adding XSLT Values with Matching Headings

RabbitPack · August 5th, 2009, 06:08 PM

Hello everyone. I literally love this site and the community, usually I can find problems by reading through your forums, but I haven't been able to find something to help me on my most recent problem. Any help? Thanks.

Here's a snippet of my XML file:

<data>

<transaction>
<transaction_details>
<name>Nickie</name>
<number>5</number>
</transaction_details>
</transaction>

<transaction>
<transaction_details>
<name>Chris</name>
<number>2</number>
</transaction_details>
</transaction>

<transaction>
<transaction_details>
<name>Nickie</name>
<number>5</number>
</transaction_details>
</transaction>

</data>
--------------------------------------------
What I'm trying to do is add the values of the people named Nickie, and get the number 10.

Is this possible?

<xsl:value-of select= ? or is it something else?

Thanks everyone and anyone who helps.

mhkay · August 5th, 2009, 07:34 PM

sum(transaction/transaction_details[name='Nickie']/number)

RabbitPack · August 5th, 2009, 07:59 PM

Thanks for that really prompt reply I appreciate it, seriously.

Anyways, I deal mainly with just HTML and CSS, but for this project I'm doing now needs me to branch out to a little more complicated and different things.
So, I'm still having problems...

------------------
The XML

<?xml version="1.0" encoding="ISO-8859-1"?>

<data>

<transaction>
<transaction_details>
<name>Nickie</name>
<number>5</number>
</transaction_details>
</transaction>

<transaction>
<transaction_details>
<name>Chris</name>
<number>2</number>
</transaction_details>
</transaction>

<transaction>
<transaction_details>
<name>Nickie</name>
<number>5</number>
</transaction_details>
</transaction>

</data>
----------------------
The XSLT

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
<html>
<body>
<h2>RabbitPack.com</h2>
<table border="2">
<tr bgcolor="#3acd32">
<th>Nickie Total</th>
<th>Chris Total</th>
</tr>
<xsl:for-each select="data/transaction/transaction_details">
<tr>
<td><xsl:value-of select="sum(data/transaction/transaction_details[name='Nickie']/number)"/></td>
<td><xsl:value-of select="sum(data/transaction/transaction_details[name= 'Chris']/number)"/></td>
</tr>
</xsl:for-each>
</table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
------------------------------
The Output: As a table

Nickie Total____Chris Total
0_________________0
0_________________0
0_________________0
---------------------------------
Okay, my XSLT is probably all over the place

. I really just want to be able to add up and distinguish the total for each one Nickie and Chris. Help?

mrame · August 6th, 2009, 12:21 AM

Just discard <xsl:for-each select="data/transaction/transaction_details">.

Code:

...
<th>Nickie Total</th>
<th>Chris Total</th>
</tr>
<tr>
<td><xsl:value-of select="sum(data/transaction/transaction_details[name='Nickie']/number)"/></td>
<td><xsl:value-of select="sum(data/transaction/transaction_details[name= 'Chris']/number)"/></td>
</tr>
</table>
</body>
...

RabbitPack · August 6th, 2009, 05:02 AM

I love you? Probably

Thanks a million.