Hi, you could rewrite the formula using vertical sums:
|-----+------+------+-------| | No. | P | E | B | |-----+------+------+-------| | 1 | 5000 | 2000 | 3000 | | 2 | 7000 | 1000 | 9000 | | 3 | 5000 | 1000 | 13000 | #+TBLFM: $4=vsum(@-i$...@0$2)-vsum(@-i$...@0$3) HTH Andreas On Sat, 26 Sep 2009 03:08:11 +0000 (UTC) RC <re...@yahoo.com> wrote: > Hi, > On applying the column formula on the table shown below: > |-----+------+------+----------| > | No. | P | E | B | > |-----+------+------+----------| > | | | | 0 | > | 1 | 5000 | 2000 | | > | 2 | 7000 | 1000 | | > | 3 | 5000 | 1000 | | > #+TBLFM: $...@-1$4+$2-$3 > > I get: > |-----+------+------+-----------| > | No. | P | E | B | > |-----+------+------+-----------| > | | | | B | > | 1 | 5000 | 2000 | B + 3000 | > | 2 | 7000 | 1000 | B + 9000 | > | 3 | 5000 | 1000 | B + 13000 | > #+TBLFM: $...@-1$4+$2-$3 > > When what I would like is: > |-----+------+------+-------| > | No. | P | E | B | > |-----+------+------+-------| > | | | | 0 | > | 1 | 5000 | 1000 | 3000 | > | 2 | 5000 | 1000 | 9000 | > | 3 | 5000 | 1000 | 13000 | > #+TBLFM: $...@-1$4+$2-$3 > > Is there a way I can restrict application of the column formula to below the > horizontal line. > Thanks, > RC > > > > > _______________________________________________ > Emacs-orgmode mailing list > Remember: use `Reply All' to send replies to the list. > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode _______________________________________________ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
