Hi,
I have a problem where i need to calculate totals in a table that are based on previous values and calculations.
I am currently doing that in a function which works fine but was wondering if there is a more elegant or efficient way to do this.
Here is an example table, ordered by row no.
The total is based on the previous rows. Note that the difference of a values does not always need to be 1
row | a | b | total |
------+----+-------+------- +
1 | 3 | 11 | 0 |
2 | 5 | 34 | 22 |
3 | 6 | 64 | 67 |
4 | 7 | 525 | 176 |
5 | 8 | 9994 | 810 |
6 | 9 | 26216 | 11438 |
7 | 10 | 3363 | 48282 |
8 | 11 | 1147 | 88489 |
9 | 12 | 1037 | 129843 |
10 | 13 | 200 | 172234 |
Total Row 2
(a2-a1)*b1
i.e. (5-3)*11 = 22
Total Row 3
(a3-a2)*b2 + (a3-a1)*b1
i.e (6-5)*34 + (6-3)*11 = 34+33=67
Total Row 4
(a4-a3)*b3 + (a4-a2)*b2 + (a4-a1)*b1
i.e (7-6)*64 + (7-5)*34 + (7-3)*11 = 64+68+44=176
Has anyone a clever solution for that problem?
Thanks for any suggestions.
Alex