Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Avg Summary for a Field

Status
Not open for further replies.

sopomeres

MIS
Jan 16, 2003
61
US
I need to insert a Summary that averages a field's values, but it needs to overlook any '0' values. Any idea?

Thanks!
 
Hi

I did something similar some time ago.

I wanted to suppress a group if the value was 0. I put a Supress if on the group and then added a formula.

Sum ({MEWTACTGVALUES1.TOTLABTIME_AMT}, WORKORDERTYPE1.ID}) <= 0.00

You might be able to ues any of it.

// Christina
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top