Hi all,
I am having some formatting and/or defaulting troubles with measures. How
can I default blank measures to a zero?

Also, I have a calculated measure that I am using for Standard Deviation,
THANK YOU Deepak Puri for you help with that one, and it is returning me a
1.$. It is on a money datatype, but that default is weird, how do I make it
a zero or a null?

Calculated measure returning the 1.$
member [Measures].[Population StdDeviation] as
'(([Measures].[WKCESSMathSquared] - ([Measures].[WKCESSMath] ^ 2) /
[Measures].[WKCESSMathCount]) / [Measures].[WKCESSMathCount]) ^ .5', format
= '0.0'

thank you all so much for all your help,
tim

Hi Tim,

Can't quite understand why you are getting "1.$" - maybe someone else
can help. But here's more info on formats:

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/agmdxadvanced_2aur.asp

The cell property FORMAT_STRING is used to format the VALUE cell
property, creating the value for the FORMATTED_VALUE cell property. The
FORMAT_STRING cell property handles both string and numeric raw values,
applying a format expression against the value to return a formatted
value for the FORMATTED_VALUE cell property. The following tables detail
the syntax and formatting characters used to handle string and numeric
values.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***