torys.ander...@gmail.com (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(@I..@II)::$ttl=vsum(@I..@II)
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(@I..@II)::$ttl=vsum(@I..@II) -- Dobbelt-A
