Calculate by rows

[tgrondona]

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!

[gabrielvilella]

Here is an example on how to use the multi row formula.

[tgrondona]

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.

[gabrielvilella]

Please provide a sample dataset of the input data and desired output. 

[tgrondona]

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!

[gabrielvilella]

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]

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

Tks