SSDN - Rounding of Numbers Issue

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9

K J

Subject: Rounding of Numbers Issue
Author: K J
Date: 03 Jul 2006 12:19 PM

Hi all,

I have a stylesheet that multiples the value of X & Y and compares this to value Z.

Value X = 278958
Value Y = 945.3
Value Z = 263698997.4

The multiplication of these is: 263698997.39999998 in the stylesheet.
When compared to Z this test fails as X*Y is just under the value of Z. I need to maintain 2 decimal places in the calculation,

Any ideas anyone?
Thanks,

Ivan Pedruzzi

Subject: Rounding of Numbers Issue
Author: Ivan Pedruzzi
Date: 03 Jul 2006 12:52 PM

Please have a look to format-number

http://www.w3.org/TR/xslt#format-number

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

paul e

Subject: Rounding of Numbers Issue
Author: paul e
Date: 04 Jul 2006 07:41 AM

the following would multiply invval by -1 and format the output to 2 decimal places (with no thousand separater).

select="format-number((invval * -1),'##.00')"

the first parameter is the value to be formatted and the second is the format mask to use.

if you want to reuse multiple decimal formats in your xslt have a look at the xsl:decimal-format command.

hope that helps
Paul

Topic Page 1 2 3 4 5 6 7 8 9

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.