Re: how do I find the sum for nested elements???

Thanks for solution Joshua ...............

Garrick

----- Original Message -----
From: <Joshua.Kuswadi@xxxxxxxxxxxxxxxxxxxx>
To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
Sent: Thursday, December 06, 2001 12:05 PM
Subject: RE:  how do I find the sum for nested elements???


> Hi Garrick,
>
> For the below structure: (Note I've added a document element)
> <AgentList>
> > <AgentInfo>
> >     <MerchantList>
> >          <MerchantInfo>
> >              <Bal>10</Bal>
> >          </MerchantInfo>
> >          <MerchantInfo>
> >              <Bal>10</Bal>
> >          </MerchantInfo>
> >     </MerchantList>
> >   </AgentInfo>
> >    <AgentInfo>
> >       <MerchantList>
> >            <MerchantInfo>
> >                 <Bal>10</Bal>
> >            </MerchantInfo>
> >            <MerchantInfo>
> >                 <Bal>10</Bal>
> >            </MerchantInfo>
> >       </MerchantList>
> >   </AgentInfo>
> <AgentList>
> >
> >
> > I need the Total Balance i.e Grand Total for all Merchants
> > ....and also the
> > Total Balance Agent wise using XSL
>
> something like this should return the desired result. (I'm assuming you
want it in an HTML table format)
> <xsl:stylesheet>
> <xsl:template match="/AgentList">
>  <table>
>   <xsl:apply-templates select="AgentInfo" />
>   <tr>
>    <td>Grand total</td>
>    <td><xsl:value-of select="sum(AgentInfo/MerchantList/MerchantInfo/Bal)"
/></td>
>   </tr>
>  </table>
> </xsl:template>
>
> <xsl:template match="AgentInfo">
>  <tr>
>   <td>Agent: <xsl:value-of select="position()" /></td>
>   <td><xsl:value-of select="sum(MerchantList/MerchantInfo/Bal)" /></td>
>  </tr>
> </xsl:template>
> </xsl:stylesheet>
>
> >
> > eg Grand Total =40
> > (Agent wise)Total=20
>
> HTH,
> Joshua
>
> --------------------------------------------------------------------------
----
> This message and any attachment is confidential and may be privileged or
otherwise protected from disclosure.  If you have received it by mistake
please let us know by reply and then delete it from your system; you should
not copy the message or disclose its contents to anyone.
>
>
>
>
>
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list