Formula change

[psperry2]

I have this formula in a report footer:

=Sum([Elapsed_Days])/Count([Elapsed_Days])

What I need to change is to get the count function to not count when the Elapsed Days value is zero. I want the Average to not be wrong because of bad data.

I was thinking that some kind of a SQL stmt would be better but I am having a mental block trying to get it started.

 

[psperry2]

This didn't work:

=Sum([Elapsed_Days])/Count([Elapsed_Days]>0)

 

[psperry2]

Solved the problem, I made sure that if the Elapsed Days was going to be invalid, I set it to NULL and then the Count Function won't count it.

Give me a star please!