You might be able to use a calculation like
IFNULL ([measure], "blank")
I have used that to put zeros in the null places to ensure my averages work correctly.
Hope that helps,
If it is a measure, the null values should show up as blank already. Dimensions when null show up as 'null' in the view. If you are saying you want to change the null text to space, it should just be:
The calculation which you guys gave isn't working for the measure.
I used the below calculation
IFNULL( STR([Measure]),'') . It worked but i am not able to format the Numbers in it.
You're mixing strings and numbers.
A blank is a string value. It's no longer a number, so you can't format it as a number.