Re: Table Formula: Update column, then update value

[Eric S Fraga <e.fraga@ucl.ac.uk>]

[-- Attachment #1: Type: text/plain, Size: 1617 bytes --]

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

[-- Attachment #2: signature.asc --]
[-- Type: application/pgp-signature, Size: 180 bytes --]