Capture.PNG
Quote:
Originally Posted by Chellebell1689
Oh, I think I see what you mean...
100 - 20 - 30 = 50, right? (just an example)
So basically E would be the total you want, F and/or G is how many you have, then H is what's still needed. I just want to make sure I understand properly.
|
no
E is stock in office
F is inventory held by tech1
G is inventory held by tech2
H is overall stock be E,F,G
if i give F or G inventory i want to subtract from E "office" and still have total in H
i already have E,F,G added to H and when i subtract inventory from F and G my totals are correct in H but its not subtracted from E
ive updated pic because the first one had wrong imputs
also attached the file