How do you round numbers up.. I just see rounding off the
decimal places. Can you round to maybe the nearest
hundreth?

-mike

You can use the VBA Round function to round to the nearest 100th.
E.g.
WITH MEMBER measures.Foo as 'Round(1.23456789, 2)'
select {measures.Foo} on 0
from sales

Excel also has rounding functions available which may be of interet such as
Floor and Ceiling.
E.g.
WITH MEMBER measures.Foo as 'Excel!Ceiling(1.23456789, .01)'
select {measures.Foo} on 0
from sales

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"mike morse" <mike.morse (AT) micromo (DOT) com> wrote

Matt,
Sorry about the confusion. I meant Round to the nearest
hundred, or possibly thousand.

mike

Hi Michael,

To round to the nearest hundred, we can try to first divide the number by
100, round it and multiple the result by 100,

e.g. 100 * ROUND(123.3436/100)

The Round function is as follows:
Round(expression[, numdecimalplaces])

numdecimalplaces
Optional. Number indicating how many places to the right of the decimal are
included in the rounding. If omitted, integers are returned by the Round
function.


Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------

The VBA Round function takes a second argument that indicates how many
decimal places after the decimal you want. My first example will round to
the nearest 100th.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

""Bill Cheng [MSFT]"" <billchng (AT) online (DOT) microsoft.com> wrote