Re: [Orgmode] Spreadsheet field referencing problem

[Stephan Schmitt]

Hi Tassilo,

one solution would be:

| Datum            | Anzahlung | Sonderzahlung | Monatsrate | Restbetrag |
|------------------+-----------+---------------+------------+------------|
|                  |           |               |            |      79000 |
|------------------+-----------+---------------+------------+------------|
| <2009-10-30 Fri> |      7000 |             0 |          0 |      72000 |
| <2009-11-15 Sun> |         0 |             0 |       1000 |      71000 |
| <2009-12-15 Tue> |         0 |             0 |       1000 |      70000 |
#+TBLFM: address@hidden - vsum($2..$4)::@2$5=79000

hth,
        Stephan

Tassilo Horn wrote:
> Hi all,
> 
> I have a table like this:
> 
> | Datum            | Anzahlung | Sonderzahlung | Monatsrate | Restbetrag |
> |------------------+-----------+---------------+------------+------------|
> |                  |           |               |            |      79000 |
> |------------------+-----------+---------------+------------+------------|
> | <2009-10-30 Fri> |      7000 |             0 |          0 |            |
> | <2009-11-15 Sun> |         0 |             0 |       1000 |            |
> | <2009-12-15 Tue> |         0 |             0 |       1000 |            |
> 
> In the last column "Restbetrag" I want to have a column formula, so that
> I get these values:
> 
> | Datum            | Anzahlung | Sonderzahlung | Monatsrate | Restbetrag |
> |------------------+-----------+---------------+------------+------------|
> |                  |           |               |            |      79000 |
> |------------------+-----------+---------------+------------+------------|
> | <2009-10-30 Fri> |      7000 |             0 |          0 |      72000 |
> | <2009-11-15 Sun> |         0 |             0 |       1000 |      71000 |
> | <2009-12-15 Tue> |         0 |             0 |       1000 |      70000 |
> 
> So the formula should take the value from the cell above, and substract
> the sum of the other values in that row.  So I came up with the formula
> 
>      #+TBLFM: address@hidden - vsum($2..$4)
> 
> but recalculating the table gives that:
> 
> | Datum            | Anzahlung | Sonderzahlung | Monatsrate | Restbetrag      
>    |
> |------------------+-----------+---------------+------------+--------------------|
> |                  |           |               |            | Restbetrag      
>    |
> |------------------+-----------+---------------+------------+--------------------|
> | <2009-10-30 Fri> |      7000 |             0 |          0 | Restbetrag - 
> 7000  |
> | <2009-11-15 Sun> |         0 |             0 |       1000 | Restbetrag - 
> 8000  |
> | <2009-12-15 Tue> |         0 |             0 |       1000 | Restbetrag - 
> 9000  |
> 
> How do I get it right?
> 
> Bye,
> Tassilo
> 
> 
> 
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> address@hidden
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode