Silly question but I have a column called CP ...

(Mike Rundell) #1

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 ?

(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))

(Mike Rundell) #3

@Levent_KULACOGLU thank you well I got it working thanks to your help now to work out whether it is possible to show at the top of a table view in a slice !