none
Need Mdx query

    Question

  •  

    Hi,

     

    Below is the calculated o/p .I want to show data  5301.53333333333 till 2 digits after dot i.e 5301.53. Need MDX synatx to do this .

     

    Quany for mnth
    5301.53333333333
    1366.4
    2812.26277372263
    59497.358490566
    135822.5
    107562.8125
    150820.747252747
    264417.694968553

     

     

    Nav

    Monday, August 04, 2008 1:33 PM

All replies

  •  

    Have you applied a format string to the calculation at all?  By adding a format string you should be able to control the decimal places that are displayed by the output.  Something like #.00 if you always want to display two decimal places.  Otherwise you could look at implementing some Rounding, but remember that SSAS Rounding uses Bankers Rounding, so anything ending in .5 would get rounded to the nearest even number.

    Monday, August 04, 2008 3:29 PM