decimal values in pl/sql
How to display a value as follows in oracle: 99.99 as 99.9900, 99.9 as 99.9000, 9.99 as 9.9900, 99 as 99.0000 All cases should be satisfied.. Please help... ...
rounding
How can I round a decimal to the nearest even number in SQL?
Hi, I need to round a decimal in a sql query on Oracle 10g to the nearest even number. If the number is even, it should be returned. If the number is odd, the next even number should be returned. This is what I want: 8.05 should return 8.06, 3.48 should return 3.48 How can I do this? Thanks, Andrew ...
Rounding off floats with ostringstream
Hi, I have an issue regarding conversion from float to c++ string using ostringstream. Here is my line: void doSomething(float t) { ostringstream stream; stream << t; cout << stream.str(); } when t has value -0.89999 it is round off to -0.9, but when it's value is 0.0999 or lesser than this say 1.754e-7, it just prints w...
Issue with precision of Ruby math operations
Do you know how to fix the following issue with math precision? p RUBY_VERSION # => "1.9.1" p 0.1%1 # => 0.1 p 1.1%1 # => 0.1 p 90.0%1 # => 0.0 p 90.1%1 # => 0.0999999999999943 p 900.1%1 # => 0.100000000000023 p RUBY_VERSION # => "1.9.2" p 0.1%1 # => 0.1 p 1.1%1 # => 0.10000000000000009 p 90.0%1 # => 0.0 p 90.1%1 # => 0.099999999999994...
How do I round down a decimal to 2 decimal places in .Net?
This should be easy, but I can’t find a built in method for it, the .net framework must have a method to do this! private decimal RoundDownTo2DecimalPlaces(decimal input) { if (input < 0) { throw new Exception("not tested with negitive numbers"); } // There must be a better way! return Math.Truncate(input * 100) / ...
XSL - rounding/format-number problem
Hi guys, I'm trying to get the value of a number to 2 dec places from my xml. XML:<Quantity>0.0050</Quantity> XSL:<xsl:value-of select="format-number($quantity, '####0.00')" /> However XSL seems to have a problem with this value and outputs 0.00 in one area of the page and 0.01 in the other. Of course in this situation it is favourab...
A better Ruby implementation of round decimal to nearest 0.5
This seems horrible inefficient. Can someone give me a better Ruby way. def round_value x = (self.value*10).round/10.0 # rounds to two decimal places r = x.modulo(x.floor) # finds remainder f = x.floor self.value = case when r.between?(0, 0.25) f when r.between?(0.26, 0.75) f+0.5 when r.between?(0.76, 0.99) f+...
Rounding Standards - Financial Calculations
I am curious about the existence of any "rounding" standards" when it comes to the calculation of financial data. My initial thoughts are to perform rounding only when the data is being presented to the user (presentation layer). If "rounded" data is then used for further calculations, should be use the "rounded" figure or the "raw" fig...
Python: a could be rounded to b in the general case.
As a part of some unit testing code that I'm writing, I wrote the following function. The purpose of which is to determine if 'a' could be rounded to 'b', regardless of how accurate 'a' or 'b' are. def couldRoundTo(a,b): """Can you round a to some number of digits, such that it equals b?""" roundEnd = len(str(b)) if a == b:...
Rounding a double or float?
Possible Duplicate: round() for float in C++ In cmath there is floor and ceiling, but I cannot find round. How does one round with the standard library without writing a function and dragging it around into all projects? Thanks ...
C# - Round numbers to 0 decimals
Hi I need to round numbers to 0 decimals (for a pagging system). I've already tried something like this: Math.Round(double1, 0, MidpointRounding.AwayFromZero); If the double1 be 7,2 or 7,6 i need it to round for 8 but i'm not getting that. Can someone help me, please? Thanks ...
Round number using NSNumberFormatter without using strings
Hi all, This seems really simple but I can't see that NSNumberFormatter has a function for this which is strange. I have a number, lets say 4.1. I want to round that to 5. I figured if I used NSNumberFormatter and set the roundingMode to NSNumberFormatterRoundUp I would get the desired result. But the only way I seem to be able get my n...
"wrong number of arguments" ArgumentError when using round
I am trying to convert a temperature from Fahrenheit to Celsius: puts 'Convertir grados Fahrenheit a Celcius' STDOUT.flush x = gets.chomp aprox = (x * 100.0).round(2) / 100.0 resultado = (aprox-32)/1.8 puts resultado I use the correct formula for converting Fahrenheit to Celcius: Celsius = Fahrenheit - 32 / 1.8 However, when ...
python decimals - rounding to nearest whole dollar (no cents) - with ROUND_HALF_UP
I'm trying to use Decimal.quantize() to achieve the following: - For any amount of money, expressed as a python decimal of default precision, I want to round it using decimal.ROUND_HALF_UP so that it has no cents after rounding. For example, given 1.25, I'm trying to obtain 1.00 (signifying no cents) given 1.49 I'm trying to obtain 1....
Math Question in JS - How do I get a ratio from a percentage
I'm trying to make a converter, but i don't know the formula to do this, for example, how do I get the ratio of 85694 of 30711152. So, i can get the % like 85694/30711152*100=0.28 (rounded) but how do I then get the ratio of like 1 in a 100? I believe that'd be around 1:400? But i don't know how to get it exactly or what formula to use.....
Adding an integer to a float in PHP rounds the float to 1 decimal place
For example, I have this line of code: echo 10359023529 + 0.2137582935; Why does this return: 10359023529.2 instead of: 10359023529.2137582935 ...
.Net Rounding Issue
Hello everyone. I have a rounding issue inside of .Net. I am rounding a 3 digit number down to two digits and it is causing some problems with one number. If I try to round 34.425 to two decimal places it should round it to 34.43. I am using the roundawayfromzero option and it has worked for every number in the program except for thi...
converting float to int: rounding in complex cases (ceil() and floor() not usable)
Hello, I want to convert a floating point value to its integer representation. As this will be used in comparisons, the default rounding mode (round_to_nearest) is not appropriate for me. As far as I know I can't specify the rounding mode to the FPU in a C++ standard compliant way (not even in C++0x). What are the other ways to accompli...
Rounding NSDecimalNumber
I'm having the hardest time figuring out something that seems like it should be very simple. I need to accurately round an NSDecimalNumber to a particular number of decimal places (determined at runtime.) So far as I can tell, I have two options, neither of which I like. Convert to a float, and use C rounding functions: I don't like th...
How can I round off the elements in a Perl array to just two decimal places?
I have an array with a few elements: MSN = 34.3433423432434% Chrome = 12.4343434353534% Gtalk = 32.23233543543532% ... And I'm passing this array as y-axis labels to use with a module called GD::Graph. The problem I am facing right now, is that the number are so big on the graph that they overlap with the adjacent entry...