On Thursday, 11 Sep 2014 at 10:00, Tory S. Anderson wrote: > I have a table that calculates daily cost and then sums the hours and > the weekly cost. But I can't seem to get a formula that will do the > former. > > | Date | Hours | Rate | Cost | > |--------------+-------+------+------| > | September 8 | 0.50 | 1 | 1. | > | September 9 | 2.00 | 1 | 2. | > | September 10 | 2.00 | 1 | 2. | > | September 11 | 2.00 | 1 | 2. | > | September 12 | 2.00 | 1 | 2. | > |--------------+-------+------+------| > | | 8.5 | | 399. | > | ^ | hrs | | ttl | > > #+TBLFM: $hrs=vsum(@I..II)::$ttl=vsum(@I..II) > > Before the formula above works, I end up pasting the following line > just below the last date (above the @II line): > > #+TBLFM: $4=vsum($2*$3)
>
> So, I have to copy-paste into the middle of my table, run the line,
> then cut the line back out of the table and run the lower line. I'm
> just sure there's a better way; it even seems like once upon a time I
> had something working. But is there a non-repetitive way to autofill
> the COST ($4) column between @I..II without wiping out everything
> else?
I am not sure what is the problem here. The above table works fine for
me with this TBLFM line:
#+TBLFM: $4=$3*$2::$hrs=vsum(@I..II)::$ttl=vsum(@I..II)
What is it you expect? Note, your September 8 entry for the cost is
wrong... but will get updated if you use this TBLFM line.
--
: Eric S Fraga (0xFFFCF67D), Emacs 24.4.50.1, Org release_8.3beta-320-gb5c9de
signature.asc
Description: PGP signature
