emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Orgmode] Calc formula with multi value and format string


From: Carsten Dominik
Subject: Re: [Orgmode] Calc formula with multi value and format string
Date: Wed, 10 Jun 2009 09:07:01 +0200


On Jun 10, 2009, at 12:07 AM, Michaël 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=vmean(@2..-I),vsum(@2..-I)::

Now I would like to format the meanm, but I don’t know where I should
put the format string. I tried several possibilities without success:

$LR2=vmean(@2..-I);%.2f,vsum(@2..-I)::  displays  0.67,vsum(@2..-I)
$LR2=vmean(@2..-I),vsum(@2..-I);%.2f::  displays  0.00
$LR2=vsum(@2..-I),vmean(@2..-I);%.2f::  displays  2.00

(I don’t mind which value comes first)


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


HTH

- Carsten



reply via email to

[Prev in Thread] Current Thread [Next in Thread]