From mboxrd@z Thu Jan  1 00:00:00 1970
From: Carsten Dominik <carsten.dominik@gmail.com>
Subject: Re: Calc formula with multi value and format string
Date: Wed, 10 Jun 2009 09:07:01 +0200
Message-ID: <F3B0D9CD-4602-4E64-816E-3DD794D07165@gmail.com>
References: <20090610000711.10845b38@naurin.parienti.lan>
Mime-Version: 1.0 (Apple Message framework v935.3)
Content-Type: text/plain; charset=WINDOWS-1252; format=flowed
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1MEHty-00060P-6E
	for emacs-orgmode@gnu.org; Wed, 10 Jun 2009 03:07:14 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1MEHtt-0005ym-LT
	for emacs-orgmode@gnu.org; Wed, 10 Jun 2009 03:07:13 -0400
Received: from [199.232.76.173] (port=32909 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1MEHtt-0005yg-DX
	for emacs-orgmode@gnu.org; Wed, 10 Jun 2009 03:07:09 -0400
Received: from mail-ew0-f205.google.com ([209.85.219.205]:58809)
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <carsten.dominik@gmail.com>) id 1MEHts-00066G-Qu
	for emacs-orgmode@gnu.org; Wed, 10 Jun 2009 03:07:09 -0400
Received: by ewy1 with SMTP id 1so665227ewy.26
	for <emacs-orgmode@gnu.org>; Wed, 10 Jun 2009 00:07:04 -0700 (PDT)
In-Reply-To: <20090610000711.10845b38@naurin.parienti.lan>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: =?ISO-8859-1?Q?Micha=EBl_Parienti?= <michael@parienti.name>
Cc: emacs-orgmode@gnu.org


On Jun 10, 2009, at 12:07 AM, Micha=EBl Parienti wrote:

>
> Hi,
>
> I would like to put two computed values (sum and mean) into a cell of
> a table. Reading the calc manual I found the following syntax:
>
> |---------+---------------|
> |         |         Title |
> |---------+---------------|
> | Label 1 |             0 |
> | Label 2 |             1 |
> |---------+---------------|
> | Label 3 |             1 |
> |---------+---------------|
> |         | 0.66666667, 2 |
> |---------+---------------|
> #+TBLFM: $LR2=3Dvmean(@2..-I),vsum(@2..-I)::
>
> Now I would like to format the meanm, but I don=92t know where I =
should
> put the format string. I tried several possibilities without success:
>
> $LR2=3Dvmean(@2..-I);%.2f,vsum(@2..-I)::  displays  0.67,vsum(@2..-I)
> $LR2=3Dvmean(@2..-I),vsum(@2..-I);%.2f::  displays  0.00
> $LR2=3Dvsum(@2..-I),vmean(@2..-I);%.2f::  displays  2.00
>
> (I don=92t mind which value comes first)


|---------+---------|
|         |   Title |
|---------+---------|
| Label 1 |       0 |
| Label 2 |       1 |
|---------+---------|
| Label 3 |       1 |
|---------+---------|
|         | 0.67, 2 |
|---------+---------|
#+TBLFM: $LR2=3Dvmean(@2..-I),vsum(@2..-I);f2


HTH

- Carsten=