XML, XSLT and XPATH

XML, XSLT and XPATH RSS

XPath Expression to calculate total amount for order details

Please support our XML, XSLT and XPATH advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2009

Posts: 3

Reputation: extkml is an unknown quantity at this point

Solved Threads: 0

extkml

Offline

Newbie Poster

XPath Expression to calculate total amount for order details

20 Days Ago

I have a xml file like this

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
 
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<orders>
<order orderDate="1/1/2009" orderNo="1">
<customer id="nnghiem" name="nguyen nghiem"/>
<item id="item-1" price="25000" quantity="0"/>
<item id="item-2" price="22000" quantity="3"/>
</order>
<order orderDate="2/2/2009" orderNo="2">
<customer id="lp" name="lampard"/>
<item id="item-1" price="25000" quantity="2"/>
<item id="item-2" price="22000" quantity="8"/>
</order>
<order orderDate="3/3/2007" orderNo="3">
<customer id="nnghiem" name="nguyen nghiem"/>
<item id="item-1" price="25000" quantity="7"/>
<item id="item-2" price="22000" quantity="6"/>
</order>
</orders>
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<orders>
<order orderDate="1/1/2009" orderNo="1">
<customer id="nnghiem" name="nguyen nghiem"/>
<item id="item-1" price="25000" quantity="0"/>
<item id="item-2" price="22000" quantity="3"/>
</order>
<order orderDate="2/2/2009" orderNo="2">
<customer id="lp" name="lampard"/>
<item id="item-1" price="25000" quantity="2"/>
<item id="item-2" price="22000" quantity="8"/>
</order>
<order orderDate="3/3/2007" orderNo="3">
<customer id="nnghiem" name="nguyen nghiem"/>
<item id="item-1" price="25000" quantity="7"/>
<item id="item-2" price="22000" quantity="6"/>
</order>
</orders>

Now i want to calculate total amount for each order

this is my xsl file

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
                    <xsl:for-each select="/orders/order">
                        <tr>
                            <td> <xsl:value-of select="@orderNo"></xsl:value-of> </td>
                            <td> <xsl:value-of select="@orderDate"></xsl:value-of> </td>
                            <td> <xsl:value-of select="customer/@name"></xsl:value-of> </td>
				    <td> <xsl:value-of select="sum(item/@quantity * item/@price)"></xsl:value-of></td>
                        </tr>                        
                    </xsl:for-each>
                    <xsl:for-each select="/orders/order">
                        <tr>
                            <td> <xsl:value-of select="@orderNo"></xsl:value-of> </td>
                            <td> <xsl:value-of select="@orderDate"></xsl:value-of> </td>
                            <td> <xsl:value-of select="customer/@name"></xsl:value-of> </td>
				    <td> <xsl:value-of select="sum(item/@quantity * item/@price)"></xsl:value-of></td>
                        </tr>                        
                    </xsl:for-each>

When i transform xml+xsl => html, an error occured at the line

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
<xsl:value-of select="sum(item/@quantity * item/@price)"></xsl:value-of>
<xsl:value-of select="sum(item/@quantity * item/@price)"></xsl:value-of>

I can only guess that my xpath - expression is not correct, i also tried this:

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
<xsl:value-of select="sum(item/@quantity * @price)"></xsl:value-of>
<xsl:value-of select="sum(item/@quantity * @price)"></xsl:value-of>