I'm having an issue with calculated fields in a pivot table formula. I've tried everything and reverted back to my original simple formula in my attachment.

Any sum greater than zero works fine however I'm having issues with "zeroes". If the sum is truly zero (i.e. the data source cells = 0) I want the standard display of "0" however if the sum is blank (i.e. the data source cells are empty or N/A) I want it to display a "blank", not a zero. I need to be able to see both blanks and zeroes on my pivot table.

i.e. if the columns are 1Q, 2Q, 3Q, 4Q
then row one should be 1,1,0,blank
and row two should be 2,2,1,blank

Attachment 379728

Thanks.