If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subtotals
I have a sales order report that I want to display the units ordered subtotal
if the ship quantity is zero and/or the line item is open; and the units shipped if the quantity shipped is greater than zero and/or the line item is closed. (if any quantity is shipped that line item is closed). currently I have this for the line item subtotal: SubtotalSO: CCur(tblSOTransactions.UnitPriceSO*[UnitsOrderedSO]) And it displays the units ordered subtotal regardless of whether the line item is open or quanities have been shipped, creating a larger total for the entire report. I'm sure this is a simple if statement, but I'm at a loss. Thanks. |
Thread Tools | |
Display Modes | |
|
|