Need sum of an calculation for the next calculation

[Newhaven]

Hello!

I need a calculation in a script.

Value 1 + Value 2 = Sum

Problem now, my sum is the value 1 for the next day.

Day	Value 1	Value 2	Sum
1	10	2	12
2	12	5	17
3	17	6	23
4	23	3	26
5	26	2	28
6	28	1	9

I did not find a solution. Tried with an applymap, but this dosn't work.

Anyone a idea?

Thx!

[rubenmarin]

Hi, if it's for script you can use peek(), if it's on front end you can use Above() like:

RangeSum(above(Sum(Value1)+Sum(Value2),0,Rowno()))