I have a report which contains lines with all zero values that refuse to go away (for printing) even though I have zero suppression on print 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. 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 returns a zero value.

In my test line, if I manually 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

Richard,

I'm not sure if this if causing your problem or not, but sometimes in Excel (and, I suspect, also in Financial Reporter) a division operation returns trailing amounts (as in 9/3=3.00000000000000012). Of course, this is not zero, so the "suppress when zero" test fails.

You can see if this is the problem by changing the formula to something like, ROUND(F33/F50,2).

Hello Richard,

Copying the contents of a cell, also copies its formatting. Typing in the formula preserves the existing formatting.

My guess is that the row has "zero suppress" turned off.