I'm trying to count the number of late orders (not items) for a report.
The data looks as follows:
Bill of Lad Order Item Transport Late
123 1 1 10 1 (yes)
124 1 2 10 0 (no) (Entire order should be late)
-------------------------------------------------------
125 2 1 11 0
126 3 1 12 0
Both items shipped on the same transport. Since Item# 1 is late and item# 2 is not the entire order should be counted as "late".
I have a Count function in the Grand Totals to count unique orders so the order count above would be "3" and number of late orders SHOULD be "1", but I don't know how to accomplish this.
Please help.
Edited by dhazen - 07 Jul 2010 at 1:04pm