Re: Round up a number to 4 decimal positions

On Tue, Mar 19, 2013 at 5:26 PM, John Yeung <gallium.arsenide@xxxxxxxxx>wrote:

I'm not challenging whether the requirement makes sense. The point of
asking these things is: If you're working with numbers other than
whole numbers, most likely you're working with floats. And if you're
doing that, you're inherently introducing funky, unintuitive numerical
behaviors.

I agree floats can be funky...

But he's not dealing with floats, remember this is and has always been
business system. So there's another option besides integer and floats.
Namely, fixed decimal. In which case we do have an exact 0.2
and consequently an exact 3 * 0.2.

As long as you manipulate the decimal values within the
system's precision and scale you will always have exact answers.

The problem occurs when you move outside the limits. One simply needs to
understand the precision rules when dealing with fixed decimal.

Charles