[Mondrian] question about rounding

John V. Sichi jsichi at gmail.com
Fri Apr 6 22:12:44 EDT 2007


The following query returns 0, whereas if the quotient is 51/100, it 
returns 1.

with member [Measures].x as '50/100', format_string = '0'
select {[Measures].x} on rows
from sales;

Is there a reason it matches BigDecimal.ROUND_HALF_DOWN instead of the 
much more common BigDecimal.ROUND_HALF_UP?  Is 
BigDecimal.ROUND_HALF_DOWN required by the Visual Basic format string 
standard?

JVS



More information about the Mondrian mailing list