Hi!

I have a problem calculating the sum of attributevalues for bankaccounts (similar to one posted here before I guess.....). The xml-file used is very large,so I have simplified the problem.
What I want to do, is to find the accumulated money to be transferred to each account based on the transferid-attributs for each account.

<account nr=1> should get 234 + 764 + 912 + 1002 = 2912 euros
(transferid="1" + transferid="2" + transferid="5" + transferid="7")
transferred to his account after all the tranfers have been done.

If it is possible, I also want to calculate the accumulated amount money transfered after each transfer:

transferid="1" = 234
transferid="1" + transferid="2" = 998
transferid="1" + transferid="2" + transferid="5" = 1910
transferid="1" + transferid="2" + transferid="5" + transferid="7" = 2912

simplified xxml-file:

<bank>
<account nr="1" transferid="1">
<account nr="1" transferid="2">
<account nr="1" transferid="5">
<account nr="1" transferid="7">
<account nr="2" transferid="2">
<account nr="2" transferid="4">
<account nr="2" transferid="5">
<account nr="2" transferid="6">

<transfer transferid=1 value="234">
<transfer transferid=2 value="764">
<transfer transferid=3 value="912">
<transfer transferid=4 value="1002">
<transfer transferid=5 value="34">
<transfer transferid=6 value="23">
<transfer transferid=7 value="907">
</bank>


I have tried the tip given on the other posting here by using sum(preceding-sibling::......), but it will not work.

Do anyone out there have any solution??

In XSLT 2.0:

<xsl:for-each-group select="account" group-by="nr">
  <ans account="{current-grouping-key()"
       total="{sum(/*/transfer[@transferid=current-group()/@transferid]/@value}"/>
</xsl:for-each-group>

XSLT 1.0 is considerably harder, you'll need to look up how to use Muenchian grouping.

In both cases you'll get a speed-up by defining a key to speed the lookup of transfer elements.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Thank you very much. XSLT 2.0 makes the world much more easy!!! This formula helps me with the calculation of the total amount transferred for each account after ALL the transactions have been performed.

The final problem I have, is to calculate the partial sums and also display them.
For account nr=1, I want to display the following:

transferid="1" = 234
transferid="1" + transferid="2" = 998
transferid="1" + transferid="2" + transferid="5" = 1910
transferid="1" + transferid="2" + transferid="5" + transferid="7" = 2912


I have tried to use preceding-sibling, but it will not work:

<xsl:value-of select="current-grouping-key()"/>
<xsl:value-of select="sum(/*/preceding-sibling::transfer[@transferid=current-group()/@transferid]/@value)"/>

Hope someone out there can help me!!

Your error is the "/*" at the start of the path

sum(/*/preceding-sibling::transfer

you don't want to select from "/", the root of the document, you want to select from the context node.

Something like

for-each select="current-group()"
  value-of select="sum(preceding-sibling::transfer[...]/@value)


Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference