Re: format-number/bankers' rounding problem

Play the video

Subject: Re: format-number/bankers' rounding problem
From: David Carlisle <davidc@xxxxxxxxx>
Date: Wed, 13 Jul 2011 19:15:48 +0100

On 13/07/2011 17:59, daniel whitney wrote:

I saw round-half-to-even but I actually want to round up for positive
and down for negative values. Of course I should have put that at the
very beginning of my post.

hmm wikipedia agrees with me that "bankers rounding" is half-even but whatever, so I think you want

if($n gt 0) then round($n) else (- round(-$n))

assuming you just mean 0.5 goes up or down. If you want all fractional parts to round up if positive and down if negative replace both round() with ceiling() in the above.

David

Current Thread
Re: format-number/bankers' rounding problem, (continued) daniel whitney - 13 Jul 2011 16:50:33 -0000 Michael Kay - 13 Jul 2011 17:03:09 -0000 daniel whitney - 13 Jul 2011 16:43:00 -0000 David Carlisle - 13 Jul 2011 16:45:28 -0000 Message not available David Carlisle - 13 Jul 2011 18:16:00 -0000 <=

<- Previous	Index	Next ->
Re: format-number/bankers' ro, David Carlisle	Thread	format-dateTime and time zone, Birnbaum, David J
Re: why matches($title,'.?(\, Oliver Hallam*	Date	Re: why matches($title,'.?(\, Michael Kay*
	Month

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

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >