Hi, I'm trying to execute an iterative logic for the below template
Input:
Open balance | New billing | Close balance |
0 | 0 | 100 |
50 | ||
70 | ||
80 | ||
90 |
expected Output:
Open balance | New billing | Close balance |
0 | 0 | 100 |
100 | 50 | 150 |
150 | 70 | 220 |
220 | 80 | 300 |
300 | -60 | 240 |
Here I'm trying to create an iterative loop where the close balance in 1st row is the new open balance in 2nd row and the close balance for the second row is an addition of open balance + New billing in the second row and the loop should repeat so on..
Any help would be appreciated.
Regards,
Suhail
Solved! Go to Solution.
Thanks Neil !!