SSDN - How to canculate grand total.

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

vinh vu

Subject: How to canculate grand total.
Author: vinh vu
Date: 31 Jul 2006 04:46 PM

Hi everyone,

I'm a very newbie in XSLT. I have and XML which contains PART-ID, QUANTITY and PRICE. So far, I'd be able to calculate the amount for each PART-ID (QUANTITY * PRICE) and display it using table. I'd like to calculate for the grand total of all PART-ID and display, but don't know how.

Please help.

Thank you very much in advance.

Vu

James Durning

Subject: How to calculate grand total.
Author: James Durning
Date: 02 Aug 2006 04:03 PM

If you have something like:
<PART-ID QUANTITY="11" PRICE="4>
<PART-ID QUANTITY="4" PRICE="9">

Create a temp variable $product like this:
<root>
<partid product="44">
<partid product="45">
</root>

then calculate <xsl:value-of select="sum($product//partid/@product)"/>
if you are using xsl 1.0, you need to use node-set
<xsl:value-of select="sum((exslt:node-set($product)//partid/@product)" xmlns:exslt="http://exslt.org/common"/>
namespace differs depending on processor.

vinh vu

Subject: How to calculate grand total.
Author: vinh vu
Date: 03 Aug 2006 10:00 AM

Thank you so much. It really helped.

Topic Page 1 2 3 4 5 6 7 8 9

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.