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?
In the properties for data format there are options for what characters to display for the divide by zero (/0) values.
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.