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

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 ?

0 2 303
2 REPLIES 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))

@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 !

Top Labels in this Space