Subject: Re: grouping date ranges with associated sums
From: David Carlisle <davidc@xxxxxxxxx>
Date: Mon, 29 Nov 2004 17:26:26 GMT
|
> 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(MinFlowDate,1,2))>= 20041129]
[concat(substring(MinFlowDate,7),substring(MinFlowDate,4,2),substring(MinFlowDate,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
________________________________________________________________________
|