May 6, 200817 yr 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?
May 6, 200817 yr Not really clear on the question or concept but something along the lines of If Money > 0... maybe?
May 6, 200817 yr Author 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.
May 6, 200817 yr Author 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!
Create an account or sign in to comment