Calculate by rows

Question

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!

EXAMPLE.PNG

tgrondona · Answer

I made a mistake in the last row. The date was supposed to be 05/02/2022

Tks

gabrielvilella · Answer

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?

tgrondona · Answer

The column ACC USD is the previous value + current USD + (IF change of month then ACC INT else 0)

ACC INT is the sum of previous int + current if month hasn't changed else is current INT.

Tks!

DATASET AND DESIRED OUTPUT.xlsx