I have a Measure that gives me a count of terminated emplyees and a
calculated member that gives me the average number of active employees at
each level. I would like to create a calculated member that gives me the
turnover percentage by dividing the termination count with the average number
of actives. This is what I created,
"[Measures].[Termcount]/[Measures].[AvgEmpCount]" but it gives me a blank
value at the bottom level and a value of 1 at each level above that. What am
I doing wrong?

The measure is using an integer format by default. So values below 0.5
will round down to 0 and display as blank, values of 0.5 and above will
round up to 1. The solution would be to either set a format string...

eg.

[Measures].[Termcount]/[Measures].[AvgEmpCount] ,FORMAT_STRING="0.00%"

.... or to multiply your measure by 100 ...

eg.

[Measures].[Termcount]/[Measures].[AvgEmpCount] * 100

It depends whether you want an integer amount or a "true" percentage.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <D3CBA34A-650E-4CF8-9C01-FCFEE49B1248 (AT) microsoft (DOT) com>,
BryanWheeler (AT) discussions (DOT) microsoft.com says...