Hello,

My cube looks similar to:
http://www.sql-server-performance.co...msas_12_22.jpg

As you can see there for a dimension 'fantastic discounts' cell for the
first measure is empty and for second it's equal to .00). I would like
to have there 0 and 0.00). How can I do that ??

Regards, Mark

All you should have to do is change the format String...
the following should work for you:
"#,#.00;;;0"
&
""#,#.00;;0.00"

(the first section is for Positive #'s, 2nd for Negative #'s, the 3rd
for Zeros, and the 4th for Null value formatting )

I think what you are seeing is an empty cell and a cell with a zero
value. In the advance tab for a member or calculated member there is a
property called "format string". It has a number of default options, but
you can also type in your own format string. (similar to excel)

Format strings have the format:

<positive number format>;[negative number format];[zero format];[empty
format]

so in your case you would probably be after something like:

#,##0.00;-#,##0.00;0.00;0

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

In article <1137771989.535328.214540 (AT) g14g2000cwa (DOT) googlegroups.com>,
mkazmierski (AT) gmail (DOT) com says...