Summary This xslt template will round attribute values before summing them. I know this sounds like the wrong thing to do, but it was required to insure that the credits and debits balanced when displaying general ledger information.

Additional information

<xsl:variable name="roundValue"> <xsl:for-each select="//doc/payroll/record"> <roundAmt><xsl:value-of select="round((@rate)*100)"/></roundAmt> </xsl:for-each> </xsl:variable> <xsl:value-of select="sum(msxsl:node-set($roundValue)/roundAmt) div 100"/> Since this was being used in several places, I created the following function: <xsl:stylesheet xmlns:xsl='http://www.w3.org/1999/XSL/Transform' version='1.0' xmlns:msxsl = 'urn:schemas-microsoft-com:xslt'> <xsl:output method='xml' omit-xml-declaration='yes' encoding='ASCII'/> <xsl:template match="/"> <xsl:call-template name="roundSum"> <xsl:with-param name="node" select="//doc/payroll/record"/> <xsl:with-param name="value" select="'rate'"/> <xsl:with-param name="digits" select="2"/> </xsl:call-template> </xsl:template> <xsl:template name="roundSum"> <xsl:param name="node"/> <xsl:param name="value"/> <xsl:param name="digits"/> <xsl:variable name="multiplier"> <xsl:choose> <xsl:when test="$digits=1">10</xsl:when> <xsl:when test="$digits=2">100</xsl:when> <xsl:when test="$digits=3">1000</xsl:when> <xsl:when test="$digits=4">10000</xsl:when> <xsl:when test="$digits=5">100000</xsl:when> <xsl:when test="$digits=6">1000000</xsl:when> <xsl:when test="$digits=7">10000000</xsl:when> <xsl:when test="$digits=8">100000000</xsl:when> <xsl:when test="$digits=9">1000000000</xsl:when> <xsl:otherwise>1</xsl:otherwise> </xsl:choose> </xsl:variable> <xsl:variable name="roundValue"> <xsl:for-each select="$node/@*[name()=$value~"> <roundAmt><xsl:value-of select="round((.)*$multiplier)"/></roundAmt> </xsl:for-each> </xsl:variable> <xsl:value-of select="sum(msxsl:node-set($roundValue)/roundAmt) div $multiplier"/> </xsl:template> </xsl:stylesheet>

Further additional information

<doc><!--Source--> <payroll> <record payrollID="123456" hours="40" rate="12.116" /> <record payrollID="223456" hours="40" rate="12.116" /> <record payrollID="323456" hours="40" rate="12.116" /> <record payrollID="423456" hours="40" rate="12.116" /> <record payrollID="523456" hours="40" rate="12.116" /> </payroll> </doc>

---

Rate this article on a scale of 1 to 10 (0 votes, average 0)

Your vote : 1 2 3 4 5 6 7 8 9 10  

Updating...

<< System.XML		.NET and XML (67)Ajax (2)BizTalk (55)CSS (114)JavaScript (64)LAMP (6)Microsoft ASP (90)PHP XML (89)reBlogger (0)Schemas, xsd, xdr (45)SEO (3)SQL XML (76)System.XML (39)Uncategorized (137)WCF, WS, SOAP (55)XALAN (22)XHTML (97)XML DOM (119)XmlSerializer (34)XQuery (24)XSLT (252)	WCF, WS, SOAP >>

Updating comments...

---

Updating comments...

Leave a comment for this article
Your name
Your email (optional)
Your comment
Optional: Upload an attachment
Enter the code shown: