|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] outputting unique titles and partial sums
I have been trying to get the following output
{month}:{sum of spots for that month} {month}:{sum of spots for that month}
Can someone help me spot what's not working on my code?
Here is the xml doc:
<prop_tv_station>
<prop_tv_program>
<air_month>
<month_name>September</month_name>
<num_spots>12</num_spots>
</air_month>
<air_month>
<month_name>January</month_name>
<num_spots>12</num_spots>
</air_month>
</prop_tv_program>
</prop_tv_station>
There are multiple tv programs each with a set of air_month. 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"/>
<xsl:text>
</xsl:text>
</xsl:for-each>
</xsl:variable>
<TR bgcolor="#FFFF99">
<TD valign="middle" CLASS="cne_programs_item"
colspan="9"><xsl:text> Subtotals: </xsl:text>
<!--<xsl:value-of
select="count($month-list)"/><xsl:text> programs. </xsl:text>-->
<xsl:value-of select="$monthsum"/>
</TD>
</TR>
Thanks in advance for any help!
Amy
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
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
|

Cart








