Hello all,
i am trying to remove the eliminated entries from the population (Example table showing below), but we only have identifier of account number, entity number and balance. We would like to have the netting entries be removed from the population and populate into a result (see below). I couldn't come up with a better idea how to do this. Can anyone kindly provide a great idea or advise how to do this?
Data
| 1 | 123456 | ABC | -100 |
| 2 | 123456 | ABC | 100 |
3 | 123456 | ABC | 100 |
| 4 | 123456 | ABC | 200 |
| 5 | 123456 | ABC | 100 |
| 6 | 123456 | ABC | -100 |
| 7 | 123456 | ABC | 200 |
| 8 | 123456 | ABC | 100 |
Result
| JE No. | Account Number | Entity Number | Amount |
| 4 | 123456 | ABC | 200 |
5 | 123456 | ABC | 100 |
| 7 | 123456 | ABC | 200 |
| 8 | 123456 | ABC | 100 |
