Forum Discussion
Solved
Calculate Order In-Full total with Line Detail
Hello,
I'm trying to write some sort of formula to evaluate the shipped Qty vs the Order Qty by SO # and maintain the item levle details like the example below
| SO # | ItemNumber | LineCount | OrderQty | ShipQty | In-Full? |
| SO-1 | 1 | 1 | 100 | 100 | 1 |
| SO-1 | 2 | 1 | 200 | 200 | 1 |
| SO-1 | 3 | 1 | 150 | 0 | |
| SO-1 | 4 | 1 | 75 | 75 | 1 |
| SO-1 | 5 | 1 | 22 | 22 | 1 |
| SO-1 | 6 | 1 | 65 | 0 | |
| SO-1 | 7 | 1 | 70 | 70 | 1 |
| SO-1 | 8 | 1 | 6 | 6 | 1 |
| SO-1 | 9 | 1 | 12 | 12 | 1 |
| Total | 9 | 700 | 485 | 0 |
Thanks!
3 Replies
Hi - sorry, the column headers got weird when I posted it... I'm looking to compare ShipQty and OrderQty.
I'm trying to create a measure that will show a 1 if either the order line or order total is shipped in full
