Count based on an expression

[Mark.Innes]

Hi,

I have a query that performs a number of counts and then produces an expression that is a % of 2 other sum fields.

What I am struggling to do is perform a count of the number of records in the expression that are <5

Any ideas please?

 

[namliam]

CountLessThan5: sum(iif(YourField<5;1;0))

That should do the trick

 

[Mark.Innes]

I must be doing something wrong, sorry if this sounds stupid but
I placed the "yourfield" with the field name of the expressions i.e. expr1 and now do I enter this in a new field or in the criteria of the expression?

I tried both but got an error "The expression entered contains an invalid syntax

Help

 

[namliam]

You cant be counting on the same line as your calculating....

Post a sample of your db so i can have a looksee and i will be able to give a better answer.

Regards

 

[Mark.Innes]

Thanks for your reply, I habe managed to sort it