[Mondrian] question about rounding

Julian Hyde julianhyde at speakeasy.net
Sat Apr 7 16:06:18 EDT 2007


 
> John Sichi wrote:
>
> 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?

No particular reason -- I've never given it much thought. If mondrian
doesn't do the same as MSAS, please change it.

Julian 




More information about the Mondrian mailing list