Help with either for-each or position and variables - NEWBIE

webmasterbeta

New Member
XML:
<lines>
<line type="Hire" serialised="true" ecoded="true">
<lineWeeklyRate>140.000</lineWeeklyRate>
<linePriceMultiplied>2135.0</linePriceMultiplied>
<lineQtyMultiplied>4270.0000</lineQtyMultiplied>
<accessories>
<accessory mandatory="mandatory">
<lineWeeklyRate>100</lineWeeklyRate>
<linePriceMultiplied>500</linePriceMultiplied>
<lineQtyMultiplied>1000</lineQtyMultiplied>
<warnings/>
<itemTexts/>
</accessory>
</accessories>
</line>
<line type="Hire" serialised="true" ecoded="true">
<lineWeeklyRate>140.000</lineWeeklyRate>
<linePriceMultiplied>2135.0</linePriceMultiplied>
<lineQtyMultiplied>4270.0000</lineQtyMultiplied>
<accessories/>
</line>
</lines>

I need to do the following:

For each line I need to summate the lineWeeklyRate of the line and any accessories that belong to that line.
I have tried the following and I know I need to use some sort of for-each or position, because at present the template is called for each line and summates ALL lines and accessories, hence giving the same total on all lines.

<xsl:template name="lineTotalForfait">
<xsl:variable name="mainLine"><xsl:value-of select="format-number(sum(/roots/root/record/header/lines/line/lineWeeklyRate),'########0.00')"/></xsl:variable>
<xsl:variable name="accessory"><xsl:value-of select="format-number(sum(lineWeeklyRate),'########0.00')"/></xsl:variable>
<xsl:value-of select="$mainLine + $accessory" />
</xsl:template>

Any ideas?
This is driving me mad and I know it is quite simple.

Kind Regards and Many Thanks in Advance

Chris Booth - UK
 
Back
Top