Supplier on time delivery

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Have an MRP generated Excel spreadsheet that lists Supplier shipments which
includes a calculated field indicating if a shipment is on time (date due is
subtracted from date received, which is not shown), 0 or a negative number.
I have used a pivot table to count the number of shipments from each
supplier, but how do I then count the number late (positive number) for each
so I can calculate % on time? Thanks.
Tom
 
Maybe you could add an extra column that indicates ontime/late.

=if((dateDue-DateReceived)<0,0,1)

then add this column (as Sum) to your pivottable.
 
Back
Top