count records based on criteria

[Guest]

I am trying to count records in a group footer of a report.
I have a calculated field named " DaysEL ". I want to count the number of record
that are = 0 and >0 in this field. Can this be done? I can't seem to get it right

TI

 

[Marshall Barton]

I am trying to count records in a group footer of a report.
I have a calculated field named " DaysEL ". I want to count the number of records
that are = 0 and >0 in this field. Can this be done? I can't seem to get it right.

Lots of way to do that. Here's some example expressions to
get you going:

=Count(IIf(DaysEL > 0, 1, Null))

=Sum(IIf(DaysEL > 0, 1, 0))

=Abs(Sum(DaysEL > 0))