![]() |
![]() | ![]() | ![]() | Altova Mailing List Archives>Archive Index >microsoft.public.xml Archive Home >Recent entries >Thread Prev - Decimal truncation without rounding [Thread Next] Re: Decimal truncation without roundingTo: NULL Date: 11/1/2006 2:13:00 PM Would this work? abs((floor(.086 * 100) div 100) - (floor(.07 * 100) div 100)) Sean On Nov 1, 2:41 pm, "swegele" <sweg...@gmail.com> wrote: > I have two values > 0.07 and 0.086 > > I am attemting to find the distance between the two numbers truncated > to 2 decimal places. format-number(value,##.00) rounds the value. > > so .086 - .07 should give .01 but instead I get .02 > > Any thoughts > > Sean | ![]() | ![]() | ![]() |
| Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | |||||
|
