Prevent suppressing of group when members value is > 0

[jtcmyk]

I currently have 7 character serialized records who are grouped by left ({field},6) due to the fact that every 5 records the first 6 characters are the same as such: 1010001, 1010002, 1010003, 1010004, 1010005. I need to suppress the viewing of this group if none of the fields associated with the record have a positive value.

For example the following group will be suppressed:
Number Value
1010001 0
1010002 0
1010003 0
1010004 0
1010005 0

And the following group would not be suppressed:
Number Value
1010001 0
1010002 1
1010003 0
1010004 0
1010005 0

I can get this to work on the record level, but not on the group level. Any Ideas?

 

[jtcmyk]

Never mind, thought of solution immediately after posting, thanks, jtcmyk

 

[crogers111]

Try creating a running total formula that adds the 'value' for each record

Then condtionally suppressing the GF section if the running total is = to 0

 

[lbass]

jtcmyk, You should post the solution when your solve your own issue so that the post becomes helpful to others.

-LB