Using Expressions in Reports

tim1234

Registered User.
Local time
Today, 14:29
Joined
Nov 19, 2002
Messages
38
Hello, I am trying to use some conditional expressions in a report. I am trying to "count" the "no" responses for things like "On Time Delivery" so that I can compare that to the # of shipments and determine an "Accuracy %". I have attached a .jpg that shows the fields from the query and what I have in the report thus far. I have the easy part (Total Shipments) working, Can I add something to the =Count([tblOnTime?]) to make it only count the "No's"?

I also need to add the numbers togeter from each sub-category (ontime?, proper quantity etc, so that I can calculate the weighted Supplier performance rating. The weighted values are also shown in the picture. Any help is greatly appreciated. Thank you in advance
 

Attachments

  • evaluation question.jpg
    evaluation question.jpg
    90.3 KB · Views: 131
You can a field that indicates "No" and stuff a 1 in it, else 0, then sum that field.
 
llkhoutx said:
You can a field that indicates "No" and stuff a 1 in it, else 0, then sum that field.

Roughly translated :) that means:
=SUM(IIf([YourFieldNameHere]="No",1,0))
 
Thanks!!!

Thanks everybody, I knew it would be something easy. I just couldn't figure it out.
 

Users who are viewing this thread

Back
Top Bottom