Is there anyway to display blank if measure is 0, format of measure is
deciaml


0.00 should display blank
17.23 display 17.23

If i select format string #,#.## it work fine but deciaml point is displaying


IF([Measures].[Hours] =0,0,[Measures].[Hours])

0.00 displays .
17.23 is fine 17.23


thanks
Kalyan

How about if you define 3 sections in the FORMAT_STRING, for positive,
negative and zero values, like:

#,#.##;;#

The sections are explained in this MSDN page:

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

The first section applies to positive values, the second to negative
values, and the third to zeros.

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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