Global variables and for-each

patrickero · March 11th, 2010, 09:53 AM

Hi there!
I've got xml:

<root>
<profile>
<name>xyz<name>
<salary>4<salary>
</profile>
<profile>
<name>mno<name
<salary>5<salary>
</profile>
</root>

and try to sum all the salary values and place it into table. I tried something like this:

<xsl:for-each select="root/profile">
<xsl:variable name="t"><xsl:value-of select="salary"/></xsl:variable>
<xsl:value-of select="sum($t)"/>;
</xsl:for-each>

<td><xsl:value-of select="$t"/></td>

but I can't get correct value of variable "t" outside the for-each. Please help me, what I've doing wrong?

Martin Honnen · March 11th, 2010, 10:12 AM

Well

Code:

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

sums up the salaries. Your attempt with the for-each has a 'profile' element as a context node, then sets the variable 't' to the value of the single 'salary' child element and then takes the sum of a single value.

samjudson · March 11th, 2010, 10:13 AM

If you sample XML input was actually valid XML you could use something like this:

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

patrickero · March 11th, 2010, 10:54 AM

Great! It:

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

works fine!
And one more question, how can I get a number of nodes? I'd like to calculate sum/number of nodes, what should I do? In this example (4+5)/2

samjudson · March 11th, 2010, 11:01 AM

count()

http://www.w3schools.com/xpath/xpath...s.asp#sequence

mhkay · March 11th, 2010, 03:29 PM

Remember that sum() and count() are functions that take a sequence (of numbers or nodes) as the argument. So it doesn't make sense to call them within a for-each that is iterating over that sequence - they need to be called once for the whole sequence, not once for each item within the sequence.