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?

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/

That was helpful. Thx.