Calculated Text Box Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

=Sum(IIf([LeadSecuritiesLicense]="no",1,0))/2
 
Susan said:
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.
Click to expand...


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

will work, but I think this is less confusing:

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