|
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 |
