Using Expressions in Reports

[tim1234]

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

 

[llkhoutx]

You can a field that indicates "No" and stuff a 1 in it, else 0, then sum that field.

 

[boblarson]

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))

 

[tim1234]

Thanks!!!

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