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

rounding within the "format-number" function

Subject: rounding within the "format-number" function
From: "Osheka, Susan" <SOsheka@xxxxxxxxxxxxxxxxx>
Date: Thu, 26 Jan 2006 11:03:58 -0500
format number round
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.

For example :  9.2750 rounds up to 9.28, but 9.2850 rounds down to 9.28
.
9.2950 rounds up to 9.30, but 9.3050 rounds down to 9.30.

Here is the XSLT I am using:   <xsl:value-of
select="format-number($number,'##.00')"/>

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???

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.