[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

RE: RE: Totals for conditional sums ?maybe?

Subject: RE: RE: Totals for conditional sums ?maybe?
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Tue, 6 Dec 2005 09:32:19 -0000
xslt sum conditional
> transactionAmount stores a text value(on the front end) ex: $1,000.00
> 
> I would need to sum the values and then format them (number-format?).

You can convert the values to numbers using translate($in, '/,', '')

In XSLT 1.0 sum() will only total numbers actually held in nodes, not
computed numbers. There are several ways to total computed numbers:

(a) a recursive template that computes the first number, and adds this to
the result of applying itself to the set of nodes that excludes the first
one

(b) construct a temporary tree whose nodes contain the computed numbers, and
use sum() to total over them. This requires use of the node-set() extension.

(c) use the sum() function in FXSL

(d) use the saxon:sum(node-set, expression) extension function in Saxon.

If these all sound too difficult, then try XSLT 2.0.

Michael Kay
http://www.saxonica.com/

Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.