Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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()))