Problem Counting

[#1]

I have a table (chart), with name, number and age

in one of the records the number and age are void, because the values do not exist in DB.

and another thing in my table there is an average "age ":

sum (age) / count (age)

but in the "count", it also count what is null ...

Name_Number_Age

A______200____15

B______800____23

C______360____20

D______150____31

D_______ - _____ -

count(age) = 5

I've tried to use:

if (age> = 0, count (age))

but the end result is "null" ( - )

if (age> = 0, count (age)) = - (null)

what is wrong with this formula?

[marcel_olmo]

if you upload some code or a little QV file it could be easier to us to help you.

Cheers!!

[#3]

try count(if(Age>=0 , Age , Null())) to count all the Age positive or greater than 0

JJ

[#4]

thank you ... was what I was seeking.