Shirley,
We can only guess - at least those of us unfamiliar with Hyperion Smart
View. You might post the formula you have in one of those cells that shows
'# Missing' and let us try to guess at a solution.

"Shirley" wrote:

Hi,

I am using Hyperion Smart View - similar to excel.

The cells have formula which are suppose to be zero amounts, display
#Missing, instead of 0 or - . The rest of same formula with amount display
the right amount if not equal to zero.

How should I replace #Missing to 0?

Thanks,

Shirley