Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Data Warehousing » Analysis Services » Round function in MDX
Add to briefcase

Round function in MDX Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
Mitra_Misra
Posted Monday, February 21, 2011 2:28 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 11:04 PM
Points: 18, Visits: 102
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 ROUND(18.455) is coming as 18.45

Please suggest an approach in MDX
Post #1066980
Mitra_Misra
Posted Monday, February 21, 2011 10:55 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 03, 2013 11:04 PM
Points: 18, Visits: 102
One approach is adding 0.000001 in the ROUND expression.
e.g. Round(12.45+0.000001,1)
Post #1067405
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.