XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » Rounding of Numbers Issue
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + Using XSL files to transform x... (4)
-> + Logical Operators in if test (2)
-> + xpath with predicate otherwise... (3)
-> + XSL logic help (2)
-> - Rounding of Numbers Issue (3)
-> ->Rounding of Numbers Issue
-> ->Rounding of Numbers Issue
-> + using saxon trace (option -T) ... (4)
-> + Returning a node-set (4)
-> + Dynamic columns (2)
-> + Creating an XML fragment from ... (2)
-> + Writing quot. marks with XSLT ... (3)
-> + New to XSL with Recursion/Coun... (2)
-> + Identity Transform problem. Hi... (5)
-> - How can I put static content o... (1)
-> + WYSIWYG - Changes disappearing (3)
-> + Generating DeNormalized Schema (2)
-> + Building TransforMiiX standalo... (2)
-> + Problem with xs name space in ... (2)
-> + xsl:param seems to be xsl:par... (4)
-> + Input namespace prefix problem (4)
-> + Need help with grouping (3)
-- Previous [1441-1460] [1461-1480] [1481-1500] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
K JSubject: 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,
Postnext
Ivan PedruzziSubject: 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

Posttop
paul eSubject: 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
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.