Comments
-
I can't seem to get that to work either
-
Would I do that with a formula field?
-
Again that would leave me with one of the two matching transactions and I don't want that
-
It's more that they are offsets. So my way of trying to eliminate them is that they are duplicates based on Store, Line, Item, Change Qty Abs, and Retail Abs. There is much more data not shown but they are not really relevant like comments, people's usernames, and extra store information like divisions, regions, districts,…
-
Ok so in the group by I have 1. Store, Line, Item, Change Qty Abs, and Retail Abs but what do I put in 2 and 3?
-
Your solution would give me this: I want this:
-
No that will leave me with one of the duplicates. I need all the pairs to be gone.
