emacs-orgmode
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]