Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Round function in MDX Expand / Collapse
Author
Message
Posted Monday, February 21, 2011 2:27 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, September 30, 2013 1:56 PM
Points: 18, Visits: 103
Hi,

We are rounding a measure value to 2 decimal places using ROUND function. But in MDX if the 3rd decimal place is equal to 5 it is rounding down e.g ROUND(18.455) = 18.45 . Our requirement is to round it to 18.46. Even in SSRS it is behaving the same way.

Please suggest an approach.

Post #1066978
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse