Hi,

I have 2 formatting issues.

1) Source Measures: Data coming form Table

I want to display "0" for all the empty source measures. Is there a way in
MSAS to accomplish this?

This is because the data is simply not available in the fact table for some
of the geographic regions.

2) Calculated Measures:

For calculated measures I want to display "0.00" for all zero values and the
empty cells. I used the below formula expression. The issue is it is always
displaying '0' & not '00'. Please correct my expression.

format(IIF([Measures].[Member Months]<> 0,
[Measures].[Adjustments]/[Measures].[Member
Months],0),"##.00;(##.00);#.00; #.00")

Thanks,
Sam.