Counting with 2 Conditions

  • Thread starter Thread starter TomP
  • Start date Start date
T

TomP

I created a report and would like to get a count of records with two
conditions. Here is what I entered:

=Abs(Sum(IIf([terminate]=-1,1,0)) And [caseload]="SA")

This information is entered in an unbound text.

I would like to get a total count where the terminate field (yes/not) is
checked and the caseload meets a certain criteria.

Thank you!
 
TomP said:
I created a report and would like to get a count of records with two
conditions. Here is what I entered:

=Abs(Sum(IIf([terminate]=-1,1,0)) And [caseload]="SA")

This information is entered in an unbound text.

I would like to get a total count where the terminate field (yes/not) is
checked and the caseload meets a certain criteria.
Click to expand...

=Sum(IIf([terminate]=-1 And [caseload]="SA",1,0))
or
=Abs(Sum([terminate]=-1 And [caseload]="SA"))
 
That worked! Thank you so much for your help and patience! Happy New Year!

:-)

Marshall Barton said:
TomP said:
I created a report and would like to get a count of records with two
conditions. Here is what I entered:

=Abs(Sum(IIf([terminate]=-1,1,0)) And [caseload]="SA")

This information is entered in an unbound text.

I would like to get a total count where the terminate field (yes/not) is
checked and the caseload meets a certain criteria.
Click to expand...

=Sum(IIf([terminate]=-1 And [caseload]="SA",1,0))
or
=Abs(Sum([terminate]=-1 And [caseload]="SA"))
Click to expand...
 
Back
Top