This project has moved and is read-only. For the latest updates, please go here.

Midpoint Rounding

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

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

That was helpful. Thx.