Calculated Text Box Formula

[Susan May]

I am trying to total the # of leads I have in a report. This particular
formula is looking for the word no in the field and counts that amount. What
I would like to see is not the total number of no's, but 1/2 that amount
because this lead would only count as a 1/2 lead. What do I need to add to
reduce this number by 1/2

=Count(IIf([LeadSecuritiesLicense]="no",0))

Thanks again for all the tech support I get online. I don't know how I
would get thru some of these issues with no support at work.

Susan

 

[fredg]

I am trying to total the # of leads I have in a report. This particular
formula is looking for the word no in the field and counts that amount. What
I would like to see is not the total number of no's, but 1/2 that amount
because this lead would only count as a 1/2 lead. What do I need to add to
reduce this number by 1/2

=Count(IIf([LeadSecuritiesLicense]="no",0))

Thanks again for all the tech support I get online. I don't know how I
would get thru some of these issues with no support at work.

Susan

=Sum(IIf([LeadSecuritiesLicense]="no",1,0))/2

 

[Marshall Barton]

I am trying to total the # of leads I have in a report. This particular
formula is looking for the word no in the field and counts that amount. What
I would like to see is not the total number of no's, but 1/2 that amount
because this lead would only count as a 1/2 lead. What do I need to add to
reduce this number by 1/2

=Count(IIf([LeadSecuritiesLicense]="no",0))

Thanks again for all the tech support I get online. I don't know how I
would get thru some of these issues with no support at work.

=Count(IIf([LeadSecuritiesLicense] Like "*no*", 0))

will work, but I think this is less confusing:

=Sum(IIf([LeadSecuritiesLicense] Like "*no*", 1, 0))