count values greater than zero...

[MParker]

ok...this has to be an easy thing...but for some reason, i just can't get it. i have a field called 'money'. i need to count anything in that field and have it give me a number, but i only want it to count things in that field that are greater than zero....how do i do this?

[Anuviel]

Not really clear on the question or concept but something along the lines of If Money > 0... maybe?

[MParker]

right....if money > 0...then count that as one. and then for every other field in that column that has a greater value then zero....count those as one too. that's where i'm having the problem. i can count them...and there's 24 in total. but i'm needing it to only count the values greater than zero.

[MParker]

nevermind. i figured it out....

made another field called "count equation" that is a calculation of: If ( money > 0 ; + 1 ), then created another field called count, that just does a count summary of that calculation. it works. thanks for your help anyway!