Hitachi Vantara Pentaho Community Wiki

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
rounding
rounding
Rounding method for the Round (A, B) function

Beginning with Starting in Pentaho 7.0, the Round (A, B) function rounds to the nearest positive infinity number. This rounding method is known as "Round half to ceiling." Prior to version 7, Round (A, B) used the "Round half to even" method, also called unbiased rounding, convergent rounding, statistician's rounding, Dutch rounding, Gaussian rounding, odd-even rounding, bankers' rounding or broken rounding, and is widely used in bookkeeping. This is the default rounding mode used in IEEE 754 computing functions and operators. In Germany it is often called "Mathematisches Runden".

Note: The "Round half to even" method is the default rounding mode used in IEEE 754 computing functions and operators.

Follow Perform these instructions steps to override the default "Round half to ceiling" method and use the "Round half to even" method.

...