Counting occurances inside report section

J

Jon

Hi
after creating a grouped report, the detail section contains one of two
possible values available / not available). I am trying to count the number
of each and report this in the section footer. I can count the total number
using =count([Slot]) but not sum of each. ie I need 4 Available / 2
Unavailable etc

Thanks
 
D

Duane Hookom

=Sum(Abs([UnnamedField]="Available"))
and
=Sum(Abs([UnnamedField]="Not Available"))
 
Top