Midpoint Rounding

Apr 23, 2012 at 12:48 PM

Hi there!

Want to use a method like this:


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

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

Apr 23, 2012 at 2: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:


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

That was helpful. Thx.