Re: Calculating Column Total

Thanks David for this.

But I want to pass the value of the variable which follow certain conditions. In my previous post I made the conditions too simple (sorry about that).
Also thanks for correcting me that I was matching my template to the document node.
I am trying to run

<xsl:template match="/">
    <xsl:value-of select="fns:sumMissing_template(event_template)"/>

</xsl:template>

<xsl:function name="fns:sumMissing_template">
<xsl:param name="eventTemplate " as="element()*"/>
   <xsl:variable name="Num_Docs_Missing">

    <xsl:choose>
      <xsl:when test="@complete='Y'">
         *****Some Calculations**********
      </xsl:when>
      <xsl:otherwise>
        *****Some Calculations**********
      </xsl:otherwise>
    </xsl:choose>
   </xsl:variable>

<xsl:sequence select="sum(for $x in $eventTemplate return(count(($x/event) * $Num_Docs_Missing)))"/>

</xsl:function>

<xsl:function name="fns:f" as="xs:integer">
<xsl;param name="x" as="element()"/>
<xsl:choose>
<xsl:when...
<xsl:sequence select=...
...
</xsl:function>

<xsl:temmplate match="/">
<xsl:sequence select="sum(//event/fns:f(.))"/>
</xsl:template>

Here is my XML again

<data>
     <event_template sp_doctypes="Research Note, Prior Stock Report, Stock Report">
         <event complete='Y'/>
         <event complete='N'/>
     </event_template>
     <event_template sp_doctypes=" Prior Stock Report, Stock Report">
         <event complete='Y'/>
         <event complete='N'/>
         <event complete='N'/>
         <event complete='Y'/>
     </event_template>
</data>

I am trying to achieve is the total of event*(Num_Docs_Missing) for all the event_template.

________________________________________________________________________
The Numerical Algorithms Group Ltd is a company registered in England
and Wales with company number 1249803. The registered office is:
Wilkinson House, Jordan Hill Road, Oxford OX2 8DR, United Kingdom.