Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
if you upload some code or a little QV file it could be easier to us to help you.
Cheers!!
try count(if(Age>=0 , Age , Null())) to count all the Age positive or greater than 0
JJ
thank you ... was what I was seeking.