Silly question but I have a column called CP in a table called RS and the column CP contains positive and negative values. What would the count formula and procedure be to count the number of positive and negative values in the CP column ?
Mike_Rundell1 (Mike Rundell) #1
Levent_KULACOGLU (Levent KULAÇOĞLU) #2
@Mike_Rundell1 if your values are integers: For positive, try: COUNT(SELECT(RS[CP],[CP]>0))
And for negative, try: COUNT(SELECT(RS[CP],[CP]<0))