Hi All
I've tried to figure this one out, we have
Users (User's Name) moving items (StockCode) from (From Bin) one location to another (To Bin)
Users (Column B) moving items (Column F) from (Column C) one location to another (Column D)
Users are moving items from location to location (in & out) I'm trying to calculate the difference of the in and out transactions for the user over the entire report, some cases items go in but no out. This indication is in column G (StockCode) where the stock code is duplicated showing in and out movements. I'm wondering if anyone has any ideas? I've tried a few PRODUCTSUMs but i'm having a difficult time because column F values are stacked.
I'd appreciate your review and support, thanks in advance![]()
Bookmarks