Midpoint Rounding

Apr 23, 2012 at 1:48 PM

Hi there!

Want to use a method like this:

round([Measures].[Totals],2,MidpointRounding.AwayFromZero)

... but it returns the #VALUE! error.

Did anyone know how to use the MidpointRounding enumeration with calculations?

Coordinator
Apr 23, 2012 at 3:35 PM

The Round function in MDX uses bankers rounding (i.e. MidpointRounding.ToEven). If you don't want bankers rounding, you have a few options outlined here:

http://www.bp-msbi.com/2009/08/custom-rounding-and-truncation-of/

Marked as answer by furmangg on 6/9/2014 at 3:22 PM
Apr 24, 2012 at 8:24 AM

That was helpful. Thx.