[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: grouping date ranges with associated sums
where can this code fit into the below xsl code, so that one row can be used to display sums within 3 different yearly groups? <xsl:value-of select="sum(Trade/Step [concat(substring(MinFlowDate,7),substring(MinFlowDate,4,2),substring(MinFlo wDate,1,2))>= 20041129] [concat(substring(MinFlowDate,7),substring(MinFlowDate,4,2),substring(MinFlo wDate,1,2))< 20051129] /StepCharge_TTBlack)"/> thanks, dk <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output method="html" indent="yes" /> <xsl:template match="/"> <html> <head> <title>Portfilio</title> </head> <body> <h1>Trade</h1> <xsl:apply-templates /> </body> </html> </xsl:template> <xsl:template match="Portfilio"> <table> <tbody> <xsl:apply-templates select="Trade" /> </tbody> </table> </xsl:template> <xsl:template match="Trade"> <tr> <td><xsl:value-of select="TradeId" /></td> <td> <xsl:text>total:</xsl:text> <xsl:call-template name="addSubtotals"> <xsl:with-param name="Steps" select="Step" /> </xsl:call-template> <xsl:call-template name="addSubtotals1"> <xsl:with-param name="Steps" select="Step" /> </xsl:call-template> </td> </tr> </xsl:template> <xsl:template name="addSubtotals"> <xsl:param name="Steps" /> <xsl:variable name="Step1" select="$Steps[1]" /> <xsl:variable name="RemainingItems" select="$Steps[position() > 1]" /> <xsl:variable name="subtotal" select="$Step1/StepCharge_TTBlack" /> <xsl:choose> <xsl:when test="$RemainingItems"> <xsl:variable name="subtotals"> <xsl:call-template name="addSubtotals"> <xsl:with-param name="Steps" select="$RemainingItems" /> </xsl:call-template> </xsl:variable> <br></br> <xsl:value-of select="sum(Trade/Step[concat(substring(MinFlowDate,7),substring(MinFlowDate ,4,2),substring(MinFlowDate,1,2))>=20041129] [concat(substring(MinFlowDate,7),substring(MinFlowDate,4,2),substring(MinFlo wDate,1,2))<20051129]/StepCharge_TTBlack)"/> <xsl:value-of select="$subtotal + $subtotals" /> <!-- <xsl:choose> <xsl:when test="number($MinFlowDate) >= number($currentdate) and number($MinFlowDate) <= number($datebucket1)"> 1)<xsl:value-of select="$subtotal + $subtotals" /> </xsl:when> <xsl:when test="number($MinFlowDate) >= number($datebucket1) and number($MinFlowDate) <= number($datebucket2)"> 2)<xsl:value-of select="$subtotal + $subtotals" /> </xsl:when> <xsl:when test="number($MinFlowDate) >= number($datebucket2) and number($MinFlowDate) <= number($datebucket3)"> 3)<xsl:value-of select="$subtotal + $subtotals" /> </xsl:when> <xsl:otherwise> </xsl:otherwise> </xsl:choose> --> </xsl:when> <xsl:otherwise> <xsl:value-of select="$subtotal" /> <xsl:value-of select="sum(Trade/Step[concat(substring(MinFlowDate,7),substring(MinFlowDate ,4,2),substring(MinFlowDate,1,2))>=20041129] [concat(substring(MinFlowDate,7),substring(MinFlowDate,4,2),substring(MinFlo wDate,1,2))<20051129]/StepCharge_TTBlack)"/> </xsl:otherwise> </xsl:choose> </xsl:template> <xsl:template name="addSubtotals1"> <xsl:param name="Steps" /> <xsl:variable name="Step1" select="$Steps[1]" /> <xsl:variable name="RemainingItems" select="$Steps[position() > 1]" /> <xsl:variable name="subtotal" select="$Step1/StepCharge_TTBlack" /> <xsl:choose> <xsl:when test="$RemainingItems"> <xsl:variable name="subtotals"> <xsl:call-template name="addSubtotals1"> <xsl:with-param name="Steps" select="$RemainingItems" /> </xsl:call-template> </xsl:variable> <xsl:value-of select="sum(Trade/Step[concat(substring(MinFlowDate,7),substring(MinFlowDate ,4,2),substring(MinFlowDate,1,2))>=20051129] [concat(substring(MinFlowDate,7),substring(MinFlowDate,4,2),substring(MinFlo wDate,1,2))<20061129]/StepCharge_TTBlack)"/> <!--<xsl:value-of select="$subtotal + $subtotals" />--> </xsl:when> <xsl:otherwise> <!-- <xsl:value-of select="$subtotal" />--> <xsl:value-of select="sum(Trade/Step[concat(substring(MinFlowDate,7),substring(MinFlowDate ,4,2),substring(MinFlowDate,1,2))>=20051129] [concat(substring(MinFlowDate,7),substring(MinFlowDate,4,2),substring(MinFlo wDate,1,2))<20061129]/StepCharge_TTBlack)"/> </xsl:otherwise> </xsl:choose> </xsl:template> </xsl:stylesheet> -----Original Message----- From: David Carlisle [mailto:davidc@xxxxxxxxx] Sent: Monday, November 29, 2004 12:26 PM To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx Subject: Re: grouping date ranges with associated sums > > example from today until 1 year - any MinFlowDate which falls within that > range will be summed assuming you have dd/mm/yyyy then: <xsl:value-of select="sum(Trade/Step [concat(substring(MinFlowDate,7),substring(MinFlowDate,4,2),substring(MinFlo wDate,1,2))>= 20041129] [concat(substring(MinFlowDate,7),substring(MinFlowDate,4,2),substring(MinFlo wDate,1,2))< 20051129] /StepCharge_TTBlack)"/> does the total, the same without the Trade/ at the beginning would give the sum for each trade separately (if the Trade elements were the current node in that case) David ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.802 / Virus Database: 545 - Release Date: 11/26/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.802 / Virus Database: 545 - Release Date: 11/26/2004
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|