Subject: RE: [xsl] sum function used for values within a node From: TSchutzerWeissmann@xxxxxxxxxxxxxxxx Date: Mon, 7 Oct 2002 11:23:54 +0100 |
Michael wrote: > I am returning values back from a recordset and populating > nodes with the > values. I am struggling to sum those values once they have all been > returned. > > for example: > > I am returning each value from completed_setup with a for-each loop. > > > <xsl:for each Record/Reseller_ID> > > <xsl:value-of select="./CLI/COMPLETED_SETUP"/> > > </xsl:end each> --------^^^^^^^^ surely not? so they're Record/Reseller_ID/CLI/COMPLETED_SETUP's? It always helps to show your xml. > Later on what I want to do is to sum all values held within the > <completed_setup>node and write out in a seperate cell. > The code im currently using is : > > <xsl:value-of select="sum(../CLI/COMPLETED_SETUP)"/> > > wihich is outide the above loop. does that mean, outside the above loop but in the same context as the loop? If you're having to do <xsl:for-each select="Record/Reseller_ID"> then your context is the parent of Record. If in that context you then ask for "../CLI/COMPLETED_SETUP" then from what little glimpse of your xml you've given us you're probably getting an empty node-set, unless the parent of the the parent of Record also have CLI/COMPLETED_SETUP children... How about summing "Record/Reseller_ID/CLI/COMPLETED_SETUP" instead? But this is all mere conjecture, without knowing the contexts :) > > Also is it possible to create seperate tables within the > stylesheet that > appear at after a recordset has been displayed. I have > displayed values > back from a recordset howver I wish to have a final total > table at the end > of the report which is written back. currently I have put > this as a seperate > table aoutise the loop which processes invididual customers > however this > total table appear at the bottom of each report page - I just > want it at the > end of the report. what does your xml look like? cheers, Tom XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl]how to mix two trees, Michael Kay | Thread | RE: [xsl]how to mix two trees, Jarno . Elovirta |
[xsl] sum function used for values , Jackson, Michael | Date | Re: [xsl] Re: how calculate sum(x*y, Andrey Solonchuk |
Month |