Am 19.03.2012 um 16:32 schrieb Russell Adams: > On Mon, Mar 19, 2012 at 04:01:42PM +0100, Martin Halder wrote: >> Hi all, >> >> question about table calculation. Found in the documentation that I could >> refer to e.g. first line after second hline with @II+2. >> >> Would like to calculate sum = vsum(@I..@II) and tax = sum * 0.08 >> >> Am I doing sth wrong ? >> >> Thanks for help, >> Martin >> >> | article | price | >> |---------+--------| >> | item1 | 100.00 | >> | item2 | 200.00 | >> |---------+--------| >> | sum | | >> | tax | | >> |---------+--------| >> | sum | 0 | >> #+TBLFM: >> @II+1$2=vsum(@I..@II);f2N::@II+2$2=@II+1$2*0.08;f2N::@>$2=vsum(@II..@III);f2N >> >> > > | 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 ? Thanks, Martin > ------------------------------------------------------------------ > Russell Adams rlad...@adamsinfoserv.com > > PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/ > > Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3 >