XSLT: SUM function how to
Posted: Fri Apr 03, 2009 11:55 am
Hi,
who can help me
i want to count the position of the td
xml:
xslt:
I need this output
TD1 TD2
10 10
20 1000
30 10
total 60 1020
who can help me
i want to count the position of the td
xml:
Code: Select all
<table>
<tbody>
<tr>
<td>10</td>
<td>10</td>
</tr>
<tr>
<td>20</td>
<td>1000</td>
</tr>
<tr>
<td>30</td>
<td>10</td>
</tr>
</tbody>
</table>
xslt:
Code: Select all
<xsl:template match="/">
<xsl:apply-templates/>
</xsl:template>
<xsl:template match="table">
<table border="1">
<tbody>
<xsl:for-each select="tbody/tr">
<tr>
<xsl:apply-templates select="th | td"/>
</tr>
</xsl:for-each>
<xsl:call-template name="columnTotal1"/>
</tbody>
</table>
</xsl:template>
<xsl:template match="th">
<th>
<xsl:value-of select="."/>
</th>
</xsl:template>
<xsl:template match="td">
<td>
<xsl:value-of select="."/>
</td>
</xsl:template>
<xsl:template name="columnTotal1">
<tr>
<xsl:for-each select="//tr[1]/td">
<td style="bgcolor:orange">
<xsl:value-of select="sum(//tr/td[position])"/>
</td>
</xsl:for-each>
</tr>
</xsl:template>
</xsl:stylesheet>
I need this output
TD1 TD2
10 10
20 1000
30 10
total 60 1020