How do I display zero values as blank cells?

[semsel]

I have three fields Quantity, Amount and Avg Price. Avg Price = Amount /Quantity.
Whenever the Quantity is 0 I want to force to display all three as blank cells to avoid the /0 for Avg Price. How do I achieve this?

[tjohnson3050]

In the properties for data format there are options for what characters to display for the divide by zero (/0) values.

[Lynn]

You could also try a conditional style. I would use and advanced conditional style with a condition [Quantity] = 0 and then specify "no" in the visible property on the advanced tab of the style for that condition. You could apply this property to all three elements.