average function

[#1]

I have to find the average age of servers but the problem is some of the servers have negative numbers. Is there a way to get the averages only when the age_of_servers > 0??

[swuehl · Accepted solution]

=avg( if(age_of_servers >0, age_of_servers))

or

=avg({<age_of_servers = {">0"}>} age_of_servers)