Jan 29, 2003 #1 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!
I need to insert a Summary that averages a field's values, but it needs to overlook any '0' values. Any idea? Thanks!
Jan 30, 2003 #2 Chrillef Programmer Jan 16, 2003 7 SE 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 Upvote 0 Downvote
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