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(@I..@II)::$ttl=vsum(@I..@II) --8<---------------cut here---------------end--------------->8--- Footnotes: [1] http://orgmode.org/org.html#Advanced-features
