I have a report which contains lines with all zero values that refuse to go away even though I have zero suppression turned on.

I have a test line that I use to observe the behavior and have verified that I know how to toggle the behavior successfully.

I have an account group containing a single range line referencing a single account. A cell G33 in that line contains "F33/F$50" which returns a zero value because F33 contains zero.

Cell G34 lies in the Total line, contains "=SUM(G33)", and, of course, returns a zero value.

In my test line, if I enter the text "=SUM(G33)" (contents of cell G34) into a cell, I get the proper zero suppression behavior. But! If I copy the contents cell C34 ("=SUM(G33)") and paste it into my test line, zero suppression ceases to work.

If I copy the contents of cell G33 ("F33/F$50") zero suppression appears to work properly.

So, there appears to be something fishy going on in the case that I copy the contents of a cell that resides in a Total line.

This is actually a big issue because I frequently create new reports by copying and pasting entire columns. Doing this one time essentially turns off zero suppression for the entire document which I then have to laboriously hand edit.

Is this a know bug? Is there a workaround or am I just doing something wrong.

Thanks again.

Richard