[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
Re: [xsl] Calculating Column Total
Subject: Re: [xsl] Calculating Column Total From: Mukul Gandhi <gandhi.mukul@xxxxxxxxx> Date: Thu, 25 Mar 2010 09:07:54 +0530 |
you may write a XSLT function as following, for this need: <xsl:function name="my:sumEvent_template" as="xs:nonNegativeInteger"> <xsl:param name="eventTempl" as="element()*" /> <xsl:sequence select="sum(for $x in $eventTempl return (count($x/event) * count(tokenize($x/@sp_doctypes,','))))" /> </xsl:function> and call it as following: <xsl:value-of select="my:sumEvent_template(event_template)" /> PS: this is not tested. On Thu, Mar 25, 2010 at 1:03 AM, Shashank Jain <shashankjain@xxxxxxxx> wrote: > > HI All, > > > > I am trying to calculate the total of all the columns which I am > > creating dynamically. > > > > My XML is > > > > <data> > > <event_template sp_doctypes="Research Note, Prior Stock Report, Stock > B Report"> > > B B B B <event B r_version_label="[1.0, CURRENT]" /> > > B B B B <event B r_version_label="[2.0, CURRENT]" /> > > B B B B </event_template> > > B B <event_template sp_doctypes=" Prior Stock Report, Stock Report" >> > > B B B B <event B r_version_label="[1.0, CURRENT]" /> > > B B B B <event B r_version_label="[2.0, CURRENT]" /> > > B B B B <event B r_version_label="[1.0, CURRENT]" /> > > B B B B <event B r_version_label="[2.0, CURRENT]" /> > > B </event_template> > > B </data> > > > > and this is the template I am using > > > > <xsl:template name="Col_Total_Num_Mand"> > > B B B B B <xsl:for-each select="event_template "> > > B B B B B <xsl:variable name="MandatoryDocs" select="@sp_doctypes"/> > > B B B B B <xsl:variable name="StrArray" select="tokenize($MandatoryDocsStr,',')"/> > > B B B B B <xsl:variable name="test" select="count($StrArray)"/> > > B B B <xsl:value-of select="count(child::event)*$test"/> > > B B B </xsl:for-each> > > </xsl:template> > > > > What I am trying to achieve is the total of events*(test) for all the > > event_template. > > I am able to do it for individual event_template but not able to add > them all. > > > > Thanks -- Regards, Mukul Gandhi
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
[xsl] Calculating Column Total, Shashank Jain | Thread | RE: [xsl] Calculating Column Total, Shashank Jain |
Re: [xsl] Evaluating XML inside att, Michael Ludwig | Date | Re: [xsl] Evaluating XML inside att, Jacobus Reyneke |
Month |