Subtracting from lowest value

nsyr

New Member

Join Date: Feb 2009

Posts: 3
#1

Subtracting from lowest value

Feb 20 '09, 03:17 PM

I have a table that has SeqID, BoxID, Sku, Qty. I have multiple boxes of the same item and want to subtract from the Qty with the lowest SeqID only. What are some examples of doing this?
Tags: None
ck9663

Recognized Expert Specialist

Join Date: Jun 2007

Posts: 2878
#2

Feb 20 '09, 04:37 PM

Use MIN() to find which one has the lowest value. Then subtract it from there.

--CK
Comment

Comment