I have one Group of totals that repeats 3 times on one page. There is a Group Header and Group Footer for Group 1 that repeats for Qty. 1, Qty. 2, and Qty. 3 Group.

I created formulas for Qty. 1, Qty. 2, and Qty. 3, but since the results are to all appear in the Group in the same exact spot I had to hide/stack the formulas on top of each other. I have formula_total_qty1, formula_total_qty2, and formula_total_qty3. You cannot read the numbers because they are all piled on top of each other so I suppressed the 0.00 in the formula Format Fields and then you can read the numbers because they don't write over each other.

The problem then becomes what if there is not number for formula_total_qty2 or the answer is 0.00, but since I am suppressing 0.00 the second Group Section that holds Qty. 2 totals shows a blank where I would like it to show 0.00, but it can't because if I take the zero suppression out, then you can't read the Qty. 1 totals because they are overwritten by the Qty. 2 formula totals.

This is like a Catch 22. Any way to work around this problem? I don't three separate groups would help at all. I am thinking, but so far no good ideas.

Thanks for your help ahead of time.