Record count

[johnob]

Hi all,

Im trying to get the number of records under the value of 6 ,
eg. On the report it looks like this

Date           Result

1                   5.6
2                   
3                   8.2
4                   6.6
5                   4
6                   
7                   10

And the code im using is

=Count([Result]<6)

The resulting answer is 5 , when the correct answer should be 2

Can anyone help?

Thank you

 

[pr2-eugin]

Try,

= Sum(IIF([Result] < 6, 1, 0))