Hello...
I have an issue where there is an Invoice ID that changes at various times with blanks in-between the changes and i need to calculate the total when the invoice changes. Here is a sample of the data that i am working with. The row count if over 200K lines. Any help is greatly appreciated.
I have an issue where there is an Invoice ID that changes at various times with blanks in-between the changes and i need to calculate the total when the invoice changes. Here is a sample of the data that i am working with. The row count if over 200K lines. Any help is greatly appreciated.
*Invoice ID | Line Number | *Line Type | *Amount | Invoice Quantity | Sum Total |
1001 | 1 | ITEM | 500.00 | 2 | 1900 |
2 | ITEM | 300.00 | 3 | ||
1002 | 1 | ITEM | 250.00 | 4 | 3100 |
2 | ITEM | 300.00 | 5 | ||
3 | ITEM | 100.00 | 6 | ||
1003 | 1 | ITEM | 100.00 | 4 | 3600 |
2 | ITEM | 200.00 | 1 | ||
3 | ITEM | 300.00 | 2 | ||
4 | ITEM | 400.00 | 6 | ||
1004 | 1 | ITEM | 100.00 | 2 | |
2 | ITEM | 200.00 | 1 | ||
3 | ITEM | 300.00 | 6 | ||
4 | ITEM | 400.00 | 4 | ||
5 | ITEM | 500.00 | 2 | ||
1005 | 1 | ITEM | 1000.00 | 1 | |
1006 | 1 | ITEM | 100.00 | 3 | |
2 | ITEM | 100.00 | 5 | ||
1007 | 1 | ITEM | 200.00 | 4 | |
2 | ITEM | 300.00 | 3 | ||
3 | ITEM | 400.00 | 2 | ||
1008 | 1 | ITEM | 100.00 | 1 | |
2 | ITEM | 100.00 | 2 | ||
3 | ITEM | 100.00 | 3 | ||
1009 | 1 | ITEM | 200.00 | 1 | |
2 | ITEM | 300.00 | 1 | ||
1010 | 1 | ITEM | 300.00 | 1 | |
1011 | 1 | ITEM | 100.00 | 1 | |
2 | ITEM | 100.00 | 1 | ||
3 | ITEM | 100.00 | 1 | ||
1012 | 1 | ITEM | 100.00 | 1 |