Round function in MDX

• Mitra_Misra

  SSChasing Mays

  Points: 626

  More actions

  February 21, 2011 at 2:28 am

  #149963

  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

• Mitra_Misra

  SSChasing Mays

  Points: 626

  More actions

  February 21, 2011 at 10:55 pm

  #1289687

  One approach is adding 0.000001 in the ROUND expression.

  e.g. Round(12.45+0.000001,1)