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)
-> + Duplicate Ouput on Repeating E... (2)
-> + How to canculate grand total. (3)
-> + Displaying two xml files toget... (2)
-> + Replace xml attribs vals with ... (2)
-> + check mark - font problem? (5)
-> + Xml to XML with XSLT (Remove) (10)
-> + Problem viewing xml as html wi... (4)
-> + Need to create lunk through XM... (2)
-> - Pagination with xslt (1)
-> + Transform to text using xslt (5)
-> + Rotating text using XSL FO (2)
-> + XSL -- Trim blanks from a vari... (3)
-> + dynamic matching (4)
-> + XSL:key for each condition - p... (5)
-> + XSL does not sort (5)
-> + CAN i CREATE INTERMEDIATE XML ... (2)
-> + Xml to html conversion (3)
-> + Using Xpath against Variables ... (9)
-> + XML-22004: (Fatal Error) Error... (10)
-> + Current page number (3)
-- Previous [1381-1400] [1401-1420] [1421-1440] 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.