Hi there, I am having trouble trying to calculate by rows.
As you can see in the attached example, what I want to do is to calculate row by row because my next row depends on previous values.
If the month changes, I want to add SUM_INT to SUM_USD.
Any idea how could I achieve that?
Thanks!
Thanks for the reply. The problem is that I need the accumulated sum from the previous records. That is why I cant find a solution using multi row formula.
Please provide a sample dataset of the input data and desired output.
On your file, why you do something different when the month changes on line 5, but the line below that which also has a different month, you don't do that?
I made a mistake in the last row. The date was supposed to be 05/02/2022
Tks