From mboxrd@z Thu Jan  1 00:00:00 1970
From: Christian Moe <mail@christianmoe.com>
Subject: Re: Help with column formula in radiotable
Date: Sun, 31 Aug 2014 09:53:28 +0200
Message-ID: <m2r3zxccxz.fsf@christianmoe.com>
References: <ltsqjr$pu7$1@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:57953)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mail@christianmoe.com>) id 1XNzwc-0004Jp-Tu
	for emacs-orgmode@gnu.org; Sun, 31 Aug 2014 03:53:10 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <mail@christianmoe.com>) id 1XNzwT-00036i-V0
	for emacs-orgmode@gnu.org; Sun, 31 Aug 2014 03:53:02 -0400
Received: from mail2.b1.hitrost.net ([91.185.211.205]:48776)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mail@christianmoe.com>) id 1XNzwT-00035p-NF
	for emacs-orgmode@gnu.org; Sun, 31 Aug 2014 03:52:53 -0400
In-reply-to: <ltsqjr$pu7$1@ger.gmane.org>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Thorsten Grothe <info@th-grothe.de>
Cc: emacs-orgmode@gnu.org

Hi,

You can reference the next row with @+1. If I understand your question
correctly, this works:

|---+------+-------+-------+-------+-------+---|
| ! | Jahr | Menge | Preis |  BIPn |  BIPr | W |
|---+------+-------+-------+-------+-------+---|
| # |    1 |    10 |   2.8 | 28.00 | 33.60 |   |
| # |    2 |    12 |   0.7 |  8.40 |  2.80 |   |
| # |    3 |     4 |  4.00 | 16.00 |  0.00 |   |
|---+------+-------+-------+-------+-------+---|
| _ |      |       |       |  suma |  sumb |   |
|   |      |       |       | 52.40 |  36.4 |   |
#+TBLFM: $6=@+1$3*$4;%.2f::$sumb=vsum(@II..@III)

...but you may not want to calculate the last value, since there is no
"Menge" value to calculate it with. Something like this would calculate
only the first two rows:

#+TBLFM: @2$6..@3$6=@+1$3*$4;%.2f::$sumb=vsum(@II..@III)

Yours,
Christian

Thorsten Grothe writes:

> Hello,
>
> I would like to assign a relative column formular for the 6 column (name 
> = BIPr).
>
> The formular should start in the *second field* of column 3 (value = 12) 
> and multiply it with *first value of column* 4 (value = 2.8) etc. like this:
>
> 12 * 2.8
> 4 * 0.7
> ...
>
> |---+------+-------+-------+-------+-------+---|
> | ! | Jahr | Menge | Preis |  BIPn |  BIPr | W |
> |---+------+-------+-------+-------+-------+---|
> | # |    1 |    10 |   2.8 | 28.00 |     0 |   |
> | # |    2 |    12 |   0.7 |  8.40 |       |   |
> | # |    3 |     4 |  4.00 | 16.00 |       |   |
> |---+------+-------+-------+-------+-------+---|
> | _ |      |       |       |  suma |  sumb |   |
> |   |      |       |       | 52.40 | 16.00 |   |
>
> How can I do this?
>
> Thanks in advance for your help!!
>
> Regards
> Thorsten Grothe