Pivot Table Blank Cells

[DDAZET]

I have a pivot table that compares year-on-year sales data for accounts. If an account didn't have sales for the earlier year, the custom calculation errors #DIV/0! which I can show as <blank> at the account level. Problem is at the subtotal levels, I also get the error when I should be getting a value for the group. The error for the one account is affecting my subtotal.

Is there a way I can Show Empty Cells as a VALUE instead of TEXT of say... 0.001 so I can eliminate the error messages?

 

[hemmi1]

TexasAlynn: Thanks!! This was super simple, but nothing is simple when you don't know it! Thank goodness you knew.