Counting fields

[Guest]

I am trying to create a formula to count the number of records that show a
comp ratio of greater than 80%. Comp ratio is a field name and show a result
of two fields already thru a query. This is what I have in the control
source field=Count([Comp Ratio]>80).
Please Help!!!!!

 

[Marshall Barton]

I am trying to create a formula to count the number of records that show a
comp ratio of greater than 80%. Comp ratio is a field name and show a result
of two fields already thru a query. This is what I have in the control
source field=Count([Comp Ratio]>80).

COunt counts any value that is not Null, so your expression
counts every record. Try this:

=ABS(SUM([Comp Ratio]>80))

which works because True is -1 and False is 0