Need help.
My data sometimes has more than 1 row for an item. B only occurs here and there. But, it is always preceded by an A. Everything else is just an A.
When an A - B pair exists, I need A to be changed to reflect the product of [A] + [B]. This is the desired end-state.
I was able to setup a Multi-Row Formula tool. But, that was when I was only dealing with 1 group. Now, I have to scale it to 5 Groups. I can do it, but only by threading 5 Multi-Row Formula Tools (1 for each category). Is there a better way to implement this.
Item ID | CostType | Group1 | Group2 | Group3 | Group4 | Group5 |
1001 | A | 100 | 150 | 100 | 125 | 133 |
1001 | B | -25 | -7 | -18 | -14 | -15
|
9999 | A | 54 | 56 | 56 | 78 | 89 |
The screenshot is from my actual data, so the groups (column headers) are a bit different.
Thanks!
Solved! Go to Solution.
If only there was a combined multi-row and field tool... You could:
This doesn't save you that many tools with your current data structure but is more dynamic if let's say you end up having 50 group columns.
Hope this helps.