XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » old "sum of price times quantity" problem
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + Use of before and after string (3) Sticky Topic
-> - How do I substitute element ty... (1)
-> + How does one add working days ... (4)
-> - Help, I have existing XLT and... (1)
-> + Need help on XSLT issue - (2)
-> + EDI to XML Conversion (7)
-> - XML To JSON Conversion using X... (1)
-> + Formatting Paragraphs to same ... (2)
-> - Grouping of records (1)
-> + Problems with xsd 1.1 (4)
-> + XML to HL7 mapping (3)
-> + XSLT 3 and Iterate (2)
-> + XSL-FO to PDF preview (3)
-> + java.lang.RuntimeException: Er... (2)
-> + Create Acroforms with Stylus X... (2)
-> + How to change XSLT parameter s... (3)
-> + how to change format of the da... (2)
-> + Search "Next 8 Results " doesn... (2)
-> - Support for Git (1)
-> + newbee (8)
-- [1-20] [21-40] [41-60] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
benny benSubject: old "sum of price times quantity" problem
Author: benny ben
Date: 08 Apr 2006 12:45 PM
Input xml file
<item>
<sub-item>
<qty>1</qty>
<price>2</price>
</sub-item>
<sub-item>
<qty>2</qty>
<price>3</price>
</sub-item>
</item>
<item>
<sub-item>
<qty>3</qty>
<price>4</price>
</sub-item>
</item>

Expected output total =1*2+2*3+3*4

I need to use XSLT 1.0 and I can calculate the subtotal for each item by using the recrusive template but how can I calculate the total for all items? Do I need to write 2 recrusive template?

regards,
Benny
Postnext
Minollo I.Subject: old 'sum of price times quantity' problem
Author: Minollo I.
Date: 08 Apr 2006 11:19 PM
Something like this?

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<total>
<xsl:call-template name="getTotal">
<xsl:with-param name="subItems" select="//sub-item"/>
<xsl:with-param name="index" select="1"/>
</xsl:call-template>
</total>
</xsl:template>

<xsl:template name="getTotal">
<xsl:param name="subItems"/>
<xsl:param name="index"/>
<xsl:param name="total" select="0"/>
<xsl:choose>
<xsl:when test="$subItems[$index]">
<xsl:call-template name="getTotal">
<xsl:with-param name="subItems" select="$subItems"/>
<xsl:with-param name="index" select="$index + 1"/>
<xsl:with-param name="total" select="$total + $subItems[$index]/qty * $subItems[$index]/price"/>
</xsl:call-template>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="$total"/>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
</xsl:stylesheet>

Postnext
benny benSubject: old 'sum of price times quantity' problem
Author: benny ben
Date: 11 Apr 2006 01:47 AM
Thanks.
1 more question: Will this method has performance overhead than the one using "position() >1" when there is only 2 level of document?

regards,
Benny
Posttop
Minollo I.Subject: old 'sum of price times quantity' problem
Author: Minollo I.
Date: 11 Apr 2006 11:21 AM
Not sure I understand the question; the method above may have a performance cost caused by the //sub-item search; if you have a large document, you may want to constrain that search a bit, making the path as explicit as you can... But that's not necessarily true if your XSLT processor is integrated with some form of repository that provides indexing on elements...

Minollo
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.