emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: Christian Moe <mail@christianmoe.com>
To: Thorsten Grothe <info@th-grothe.de>, emacs-orgmode@gnu.org
Subject: Re: Help with column formula in radiotable
Date: Sun, 31 Aug 2014 09:59:08 +0200	[thread overview]
Message-ID: <m2ppfhccoj.fsf@christianmoe.com> (raw)
In-Reply-To: <m2r3zxccxz.fsf@christianmoe.com>


Oops, I did misunderstand. I think this is what you wanted:

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

Here I add a formula to set the first row to 0.

Yours,
Christian

> 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

next prev parent reply	other threads:[~2014-08-31  7:58 UTC|newest]

Thread overview: 7+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2014-08-30 15:28 Help with column formula in radiotable Thorsten Grothe
2014-08-31  7:45 ` Thorsten Grothe
2014-10-12 12:19   ` Bastien
2014-08-31  7:53 ` Christian Moe
2014-08-31  7:59   ` Christian Moe [this message]
2014-08-31  8:14     ` Thorsten Grothe
2014-08-31 10:41     ` Thorsten Grothe

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=m2ppfhccoj.fsf@christianmoe.com \
    --to=mail@christianmoe.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=info@th-grothe.de \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).