[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