Average but exclusing 0

[Edgarr8]

Hello!

I have a Report in which i would like to get the average at my page footing, but i only want it to get the average if the value is greater than 0..


Name Balance
Jose 300
Jesus 0
Maria 250
Lupe 50


And i want it to give me 200 instead of the 150 if the average for everything was taken..

any ideas?

 

[ajetrumpet]

edgar,

how about using a davg() function in the control source of a footer control with criteria > 0, maybe this...

=davg("field", "underlying source", "[field] > 0")