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

RE: rounding within the "format-number" function

Subject: RE: rounding within the "format-number" function
From: "Michael Kay" <mike@xxxxxxxxxxxx>
Date: Thu, 26 Jan 2006 16:50:28 -0000
xslt rounding
> What I have noticed is that the XSL  "format-number" function 
>  rounds to
> the nearest even number, instead of the bigger one, as is usual and
> would be expected.  According to one site, this is sometimes called
> "banker's rounding." 
> Its purpose is to eliminate the slight bias that occurs when always
> rounding upwards.
> I am using XSLT 1.0.

Technically I don't think that XSLT 1.0 defines the rounding algorithm. It
defines format-number() in terms of the JDK 1.1 specification, and the JDK
1.1 specification didn't actually say what the rounding rules were. XSLT
implementations written in Java probably used the underlying JDK class
library, which did "banker's rounding", but implementations in other
languages might have used a different algorithm. XSLT 2.0 defines the rules
as you describe.
> On our pages, we want to always round up to two decimal places, and I
> don't want to lose the formatting. I would  want 9.2850 to round up to
> 9.29.   The solution that I have come up with is: 
> <xsl:value-of select='format-number( round(100*$number) div 100 ,
> "##.00" )'  
> Do you have a better solution?? Is there anyway to globally change the
> default rounding (banker's rounding) to always round up???

No, and no. (Not even in 2.0!)

Michael Kay

Current Thread


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.
First Name
Last Name
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.