RE: [xsl] outputting unique titles and partial sums

Subject: RE: [xsl] outputting unique titles and partial sums
From: "Michael Kay" <mhkay@xxxxxxxxxxxx>
Date: Mon, 6 Aug 2001 18:16:44 +0100
> And I want to
> get a list of unique months and the sum of num_spots for
> these months.  Here
> is my code:
>
>
>   <xsl:variable name="month-list"
>             select="//month_name[not(.=following::month_name) and
> not(.='')]" />
>
> 	  <xsl:variable name="monthsum">
> 		  <xsl:for-each select="$month-list">
> 		    <xsl:variable name="monthname" select="."/>
> 		      <xsl:value-of select="$monthname"/>
> 		      <xsl:text>:</xsl:text>
> 		      <xsl:value-of
> select="//air_month[month_name=$monthname]/num_spots"/>

that will give you the first num_spots for the month. If you want the sum of
all the num_spots, write

 <xsl:value-of
 select="sum(//air_month[month_name=$monthname]/num_spots)"/>

Incidentally, defining a key on month_name would help it go much faster, but
this depends on document size.

Mike Kay
Software AG


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread