Hi All,
Could I please request your help with building a workflow to process the dataset below?
What I want to achieve is: offset the positive values (from right to left) using the first negative value found from the right. The goal is to turn the positive values into zero by deducting the negative amount, and leave any remaining negative balance in its original column.
For example, in the case below, the value -284 will first offset 930.7, G = 930.7-284, and F = 0
row 2 , G (-1140.75) will offset F first , F = 5580-1140.75 , G = 0
If -1140.75 was a larger value, it would offset 5580 first, then move on to 26.4, continuing until the negative amount is fully used or no more positive values are available.
Thank you in advance
| A | B | C | D | E | F | G |
| 0 | 0 | 0 | 0 | 0 | -284 | 930.7 |
| 26.4 | 0 | 0 | 0 | 0 | 5580 | -1140.75 |
| 18 | -6 | 0 | 0 | 0 | 0 | 0 |
| 4906.7 | 2805.95 | 0 | 0 | -750 | 0 | 0 |
| -6327 | 0 | 0 | -380.67 | 200.67 | 0 | 0 |
| 0 | 0 | 0 | 0 | -881.4 | 0 | 68.2 |
| 0 | 0 | 0 | -0.49 | 7.41 | -677.47 | 0 |
| 0 | 0 | 0 | 0 | 402.33 | -578.06 | 300 |
| 0 | 0 | 750 | 0 | 0 | 0 | -744.94 |
| 135.29 | 133.44 | 0 | 0 | 4285 | 0 | -319.38 |
| 0 | 0 | 300 | 323.78 | -0.3 | 150 | 0 |
| 0 | 0 | 0 | 458 | 0 | 0 | -457.6 |
| 0 | 0 | 0 | 718.41 | 1742.3 | -546.3 | 0 |
| 435.78 | 28.93 | 287.25 | -133.29 | 410.22 | 0 | 0 |
| 36.84 | 52.62 | 213.15 | 311.36 | 0 | -106.84 | 0 |
| 0 | 561.32 | 0 | -202.6 | 405.01 | 0 | 0 |
| 0 | 331.57 | 0 | -427.84 | 45.63 | 0 | 0 |
| 0 | 0 | 0 | -54.28 | 58.62 | 0 | 0 |
