Report Calculations. Gave up after two 8 hour days trying t

[mqarep]

I have a report that keys off a parameter query for a date range.
This report gives me information on my suppliers from fields such as:
*quantity received
*quantity inspected
*quantity rejected
*responsibility (my company or our supplier, ABC_Co.or Supplier)
*supplier name

My problem is having the report calculate the percent of the quantity rejected that is the responsibility of my supplier and also the same calculation for responsibility that is my company. (for the given date range.)

In English this would be something like:
sum all rejected parts where the responsibility is "Supplier" and divide by the total quantity rejected.

It may seem simple but nothing works!

 

[SydneyGeek]

Re: Report Calculations. Gave up after two 8 hour days tryi

You might find it easier if you add another unbound field to the report that does this calculation: =Iif([Responsibility]="Supplier" and [Status]="Rejected",[QtyRejected],0)
That should split out the desired items. In the report footer, place a second textbox with the formula =Sum(Iif([Responsibility]="Supplier" and [Status]="Rejected",[QtyRejected],0)).
You can now directly compare the totals.

HTH
Denis