XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Christian BryanSubject: Running Balace (Newbie)
Author: Christian Bryan
Date: 21 Mar 2005 04:30 PM
Originally Posted: 21 Mar 2005 04:23 PM
Hi XSL'ers<br> I am having problem getting a running total to appear in a bank statement type <br> scenario. I want the XSL to calculate a balance column for each transaction on a customers<br> account. However when i use the sum(&amount) it just returns the amount of that particular<br> line not the sum of all lines up to that point in the for-each. What am i doing wrong ? I attach the whole xsl file. TIA Chunny (UK / Everton).


Unknowntncy_stmv.xsl
XSL File

Postnext
Ivan PedruzziSubject: Running Balace (Newbie)
Author: Ivan Pedruzzi
Date: 21 Mar 2005 04:35 PM
Without seeing the input XML is wild guess but try to change this

<xsl:variable name="total_bal" select="$running_bal + sum(@amount)" />

to

<xsl:variable name="total_bal" select="$running_bal + sum(../Trans/@amount)" />


Hope this helps
Ivan

Postnext
Christian BryanSubject: Running Balace (Newbie)
Author: Christian Bryan
Date: 21 Mar 2005 04:51 PM
Thanks Ivan

I think we are close.

I have attached a sample XML file.

Could you take a look please this is doing my nut !


Unknowntncy_stmv(1).xsl


UnknownTrans.xml

Postnext
Ivan PedruzziSubject: Running Balace (Newbie)
Author: Ivan Pedruzzi
Date: 21 Mar 2005 05:56 PM

If you mean the partial balance for each row try this

<xsl:variable name="total_bal" select="$running_bal + sum(preceding-sibling::Trans/@amount)"/>

Posttop
Christian BryanSubject: Running Balace (Newbie)
Author: Christian Bryan
Date: 23 Mar 2005 05:20 AM
In my excitement i forgot to say thanks !

Your are the Daddy.

Cheers

Christian.

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.