Summary This examples shows how to find the sum of 2 XML fields using Microsofts nodeset extension.

Additional information

<xsl:stylesheet xmlns:msxsl="urn:schemas-microsoft-com:xslt" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:template match="/"> <xsl:variable name="subTotal"> <related> <xsl:apply-templates select="order/item"/> </related> </xsl:variable> <table border="1"> <tr> <td>Item No.</td> <td>QTY</td> <td>Price</td> </tr> <xsl:for-each select="/order/item"> <tr> <td> <xsl:value-of select="itemNo"/> </td> <td> <xsl:value-of select="QTY"/> </td> <td> $<xsl:value-of select="price"/> </td> </tr> </xsl:for-each> <tr> <td>Total-sum(QTY*price):</td> <td colspan="2" align="right"> $<xsl:value-of select="format-number(sum(msxsl:node-set($subTotal)/related/multi),'#.00')"/> </td> </tr> </table> </xsl:template> <xsl:template match="item"> <multi> <xsl:value-of select="price*QTY"/> </multi> </xsl:template> </xsl:stylesheet>