W
Will
My report list product sales.
It groups on Product Number and on Sale or Return
If Sale is True then Qty_Shipped is how many we shipped for that order
If Return is True then Qty_shipped is how many we got back... (returned
products)
I have it summing Qty_Shipped like this =Sum([Qty_Shipped])
And it sums the Qty_Shiped for Sales and it sums Qty_Shipped for Returns.
How can I get it to subtract the Returns from the Shipped so I have net new
products shipped?
thanks for any help.
It groups on Product Number and on Sale or Return
If Sale is True then Qty_Shipped is how many we shipped for that order
If Return is True then Qty_shipped is how many we got back... (returned
products)
I have it summing Qty_Shipped like this =Sum([Qty_Shipped])
And it sums the Qty_Shiped for Sales and it sums Qty_Shipped for Returns.
How can I get it to subtract the Returns from the Shipped so I have net new
products shipped?
thanks for any help.