Re: [O] Table formulas: daily hour * rate = cost

[Rasmus]

address@hidden (Tory S. Anderson) writes:

> I have the followign table, which should speak for itself. First the
> "cost" column needs to be calculated, which is hours * rate, and then
> the "hrs" and "ttl" fields should be filled in based on sums of their
> columns. However, I'm not sure why $cost isn't being evaluated; I've
> tried it with column names as well as indices but unless I specify
> each field individually (e.g. @3$5) I can't get a result here. Formula
> debugging seems to ignore it, too. But I've been trying to follow the
> example on the "advanced feature" page[1] as closely as possible;
> what's the problem?
>
>    |   | Date        | Hours | Rate | Cost |
>    | ! |             | hours | rate | cost |
>    |---+-------------+-------+------+------|
>    |   | February 9  |  4.00 |   38 |    0 |
>    |   | February 10 |  4.00 |   38 |    0 |
>    |   | February 11 |  4.00 |   38 |    0 |
>    |   | February 12 |  4.00 |   38 |    0 |
>    |   | February 13 |  4.00 |   38 |    0 |
>    |---+-------------+-------+------+------|
>    |   |             |   20. |      |    0 |
>    | ^ |             |   hrs |      |  ttl |
>    #+TBLFM: 
> $5=$hours*$rate::$hrs=vsum(@address@hidden)::$ttl=vsum(@address@hidden)

I have no clue why, but this table works for me; the original one does
not...

   |   | Date        | Hours | Rate | Cost |
   | ! |             | hours | rate | cost |
   |---+-------------+-------+------+------|
   | # | February 9  |  4.00 |   38 | 152. |
   | # | February 10 |  4.00 |   38 | 152. |
   | # | February 11 |  4.00 |   38 | 152. |
   | # | February 12 |  4.00 |   38 | 152. |
   | # | February 13 |  4.00 |   38 | 152. |
   |---+-------------+-------+------+------|
   | # |             |   20. |      | 760. |
   | ^ |             |   hrs |      |  ttl |
   #+TBLFM: 
$5=$hours*$rate::$hrs=vsum(@address@hidden)::$ttl=vsum(@address@hidden)


-- 
Dobbelt-A