I need to calculate values by rows and after a row is updated, to update the next row using data calculated on the previous row
Let me explain with a simple example :
1.- Imagine a source with two columns, one about the payment date and another with the number of days you buy … something like this :
2.- I would like to calculate the period of time this particular customer has been paid, taking into account that the payment can be produced days before the previous period finished.
On an spreadsheet that’s easy to do it, since the formulas are calculated by rows and not by columns :
InitDate = max(EndDate_previous_row,PaymentDate)
EndDate = InitDate + DaysPaid
How can I implement a similar behavior with exploratory ?
I’ve tried to do something similar, using the lag() function to get a value from the previous row, but, since all the values of a column are calculated before the values of the row that has to be used on the formula, the result is not the expected one :
Thanks in advance