Hello how are you? I need create a formula with my ending balance to be my starting balance for the next day.
I already have the opening balance and ending balance column but the starting balance has to be updated daily based on the final balance of the previous day
Solved! Go to Solution.
Hi, have made a couple of assumptions in the below solution as not much information was provided.
Assuming you have input columns in the below format, you can simply use a multi-row formula tool to assign the ending value in the previous row to the starting value of the current row.
Sample Input
Sample tool configuration
Sample Output