Part A has QTY of 2
Part B has QTY of 3
I want a result of B of Qty 5
and A will be removed
So graphically, starts as
PN QTY
A 2
B 3
and result I want is
PN QTY
B 5
Solved! Go to Solution.
This would work for this simple scenario
Ah - nice - Thanks
Sorry for the late reply - I get pulled into rabbit holes, many times my own doing and may take me days to get back out.
This works well - other problem I just discovered with SUMMARY (I use summary module alot) is that I have to use UNION right after to bring back ALL the fields going into the SUMMARY that I still need.
Terry