[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Table formulas: daily hour * rate = cost
From: |
Tory S. Anderson |
Subject: |
[O] Table formulas: daily hour * rate = cost |
Date: |
Thu, 12 Feb 2015 07:17:29 -0500 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/25.0.50 (gnu/linux) |
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?
--8<---------------cut here---------------start------------->8---
| | 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)
--8<---------------cut here---------------end--------------->8---
Footnotes:
[1] http://orgmode.org/org.html#Advanced-features
- [O] Table formulas: daily hour * rate = cost,
Tory S. Anderson <=