adding a condition to a running total that evaluates once per group 1

[stevied66]

i have a report with two running total fields that evaluate on change of group, one of them is a count and the other is an average. i need to eliminate field values of zero from the count and average. if i change the running total to evaluate a formula, and i add {fieldname}<>0 then it skips the zeros but not the duplicates that were eliminated by evaluating on change of group. I am new to crystal reports, so I really have no clue what I am doing here. Is it possible to append the name of the group to the fieldname in the formula? I searched this forum, but can't figure out how to do that.

 

[dgillz]

Rather than messing around with your running total field, exclude zero values from your report altogether with a record selection formula of {Fieldname}<>0. Click on report, edit selection formula, record to get there.

Let me know if you have any questions. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com