[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Table formulas: daily hour * rate = cost
From: |
Rasmus |
Subject: |
Re: [O] Table formulas: daily hour * rate = cost |
Date: |
Thu, 12 Feb 2015 13:44:43 +0100 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/25.0.50 (gnu/linux) |
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