On Mon, Mar 19, 2012 at 04:45:14PM +0100, Martin Halder wrote: > > Am 19.03.2012 um 16:32 schrieb Russell Adams: > > | article | price | > > |---------+--------| > > | item1 | 100.00 | > > | item2 | 200.00 | > > |---------+--------| > > | sum | 300.00 | > > | tax | 24.00 | > > |---------+--------| > > | sum | 324.00 | > > #+TBLFM: > > @4$2=vsum(@-I..@-II);%.2f::@5$2=@4$2*0.08;%.2f::@6$2=vsum(@-I..@-II);%.2f > > > > I often use negative headline references for total lines in order to > > sum backward from the current cell. > > > > So vsum(@-I..@-II);%.2f means sum the cells between the first headline > > above the current cell to the second headline above the current cell, > > and then format the result as a decimal with two decimal places > > (%.2f). > > > > Looking at your formula, I think you manually wrote the TBLFM > > line. One thing I've found is that the TBLFM line doesn't support > > relative references for the cell specification, only in the formula. > > > > I used C-u C-c = to set mine. > > > > Good luck! > > > Hi Russell, > > right, I wrote it manually. Thanks for your formula, the problem I have is > that there > could be an "item 3" and therefore the "sum", "tax" and second "sum" lines > are not fixed. > Is there a solution to specify them dynamically or do I have to modify the > position > every time I enter a new item ? >
If you use the table editor properly, it will keep the formulas up to date for you. For instance, if you place your cursor on item2 and press return, a new line should be created and the formulas cell references corrected to match. Beware commands line C-k that may delete a row as text instead of using the Org-Mode specific table editing commands. If you want to delete a line like C-k, use M-S-Up instead. ------------------------------------------------------------------ Russell Adams rlad...@adamsinfoserv.com PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3
