Re: xml to xml transformation

 <Log>
<Entity>
  <EntityName>Michigan</EntityName>
  <Batch>
   <TotalAmount>10</TotalAmount>
  </Batch>
  <Batch>
   <TotalAmount>20</TotalAmount>
  </Batch>
  <Entity>
   <EntityName>Detroit</EntityName>
   <Batch>
    <TotalAmount>30</TotalAmount>
   </Batch>
   <Batch>
    <TotalAmount>40</TotalAmount>
   </Batch>
  </Entity>
  <Entity>
   <EntityName>Kalamazoo</EntityName>
   <Batch>
    <TotalAmount>50</TotalAmount>
   </Batch>
   <Batch>
    <TotalAmount>60</TotalAmount>
   </Batch>
  </Entity>
 </Entity>
</Loop>

I have a XML which has the structure as follows:
Each Entity Element contains 'EntityName' Element, and one or more Batch Elements. Further it may contain several other Entity Elements.
My problem is that I want to Sum the total of all the Batches belonging to each Entity(including its Sub-Entities). For Example, Michigan should give me a result of (10+20+30+40+50+60), Detroit should give a sum of (3=+40). The XML is being generated dynamically, so i dont know how many Entity elements each Entity may contain, and i want to find the sum for all the Batches(Batches/TotalAmount), including those in the Entitiey elements any deep. Any ideas how chould I go about it. In a programming world, this would be achieved through recursive functions. How Would I do this in XSLt.
Thanks in advance.
Jaskaran


____________________________________________________________
Get 25MB of email storage with Lycos Mail Plus!
Sign up today -- http://www.mail.lycos.com/brandPage.shtml?pageId=plus 

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