[XSL-LIST Mailing List Archive Home]
RE: [xsl] RE: Totals for conditional sums ?maybe?
Subject: RE: [xsl] RE: Totals for conditional sums ?maybe?|
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Tue, 6 Dec 2005 09:32:19 -0000
> 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
(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.