Can someone help I have the below problem. The first column is the PO, each PO contains a SKU or multiple SKU's
There is also columns for expected and received qty's . At the end is a % against the SKU .
What I want to do is just to have what the % is based on the PO and if there is a line with a discrepancy % then I want this also.
The way it would look is:- PO , Line High %, total PO
Data is displayed below
<colgroup><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>
There is also columns for expected and received qty's . At the end is a % against the SKU .
What I want to do is just to have what the % is based on the PO and if there is a line with a discrepancy % then I want this also.
The way it would look is:- PO , Line High %, total PO
Data is displayed below
PO Number | SKU Code | Qty Expected | Qty Received | % Complete | |
91776 | 484357 | 120 | 120 | 0% | |
98502 | 386502 | 845 | 755 | -11% | |
98502 | 386461 | 445 | 445 | 0% | |
98502 | 386450 | 150 | 150 | 0% | |
98502 | 386438 | 60 | 60 | 0% | |
98968 | 525635 | 200 | 200 | 0% | |
128387 | 894552 | 192 | 192 | 0% | |
136164 | 735435 | 300 | 300 | 0% | |
136726 | 640975 | 30 | 0 | -100% | |
136726 | 640974 | 84 | 0 | -100% | |
136726 | 640972 | 60 | 60 | 0% |
<colgroup><col><col span="2"><col><col><col></colgroup><tbody>
</tbody>