Hi,
I'd like to use a function similar to sumif in excel and output the sum in two new rows as a negative at the bottom based on the Group #. The account # for the two new rows will be the same as the example.
Input | ||
Group | Account # | Amount |
100 | 965 | 75 |
100 | 947 | 25 |
200 | 875 | 50 |
200 | 658 | 100 |
Output | ||
Group | Account # | Amount |
100 | 965 | 10 |
100 | 947 | 20 |
200 | 875 | 50 |
200 | 658 | 100 |
100 | 456 | -30 |
200 | 456 | -150 |
Thank you,
- Stuart
Solved! Go to Solution.
Hi @Stuart_C I mocked up a workflow let me know what you think?
Thank you @JosephSerpis ! This works perfectly!