[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Table Formula: Update column, then update value
From: |
Tory S. Anderson |
Subject: |
[O] Table Formula: Update column, then update value |
Date: |
Thu, 11 Sep 2014 10:00:18 -0400 |
I have a table that calculates daily cost and then sums the hours and the
weekly cost. But I can't seem to get a formula that will do the former.
| Date | Hours | Rate | Cost |
|--------------+-------+------+------|
| September 8 | 0.50 | 1 | 1. |
| September 9 | 2.00 | 1 | 2. |
| September 10 | 2.00 | 1 | 2. |
| September 11 | 2.00 | 1 | 2. |
| September 12 | 2.00 | 1 | 2. |
|--------------+-------+------+------|
| | 8.5 | | 399. |
| ^ | hrs | | ttl |
#+TBLFM: $hrs=vsum(@I..II)::$ttl=vsum(@I..II)
Before the formula above works, I end up pasting the following line just below
the last date (above the @II line):
#+TBLFM: $4=vsum($2*$3)
So, I have to copy-paste into the middle of my table, run the line, then cut
the line back out of the table and run the lower line. I'm just sure there's a
better way; it even seems like once upon a time I had something working. But is
there a non-repetitive way to autofill the COST ($4) column between @I..II
without wiping out everything else?
- [O] Table Formula: Update column, then update value,
Tory S. Anderson <=