Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have a table that I want to look like this
Area 1 Area 2
Value Change Value Change
201201 10 0 22 0
201202 18 8 20 -2
201203 25 7 24 4
..
My problem is the Change column. I nned it to show the cahnge form an period to the next
I found one forumla, but that adds the changes
=rangesum(above(column(1),1,(RowNo()-1)))//+ column(1)
How can I get the Change column to simply show the difference between from one period to another?
BR
Dan
I found a solution. Not sure it is the best one, but it solves my problem.
=rangesum(above(column(1),1,(RowNo()-1)))//+ column(1)
-rangesum(above(column(1),0,(RowNo()-1)))//+ column(1)
I found a solution. Not sure it is the best one, but it solves my problem.
=rangesum(above(column(1),1,(RowNo()-1)))//+ column(1)
-rangesum(above(column(1),0,(RowNo()-1)))//+ column(1)