thanks for the response.
where in the previous xsl document does this code need to be placed?

-----Original Message-----
From: David Carlisle <davidc@xxxxxxxxx>
Sent: Nov 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(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
________________________________________________________________________