RE: RE: Totals for conditional sums ?maybe?
> 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/
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format