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

_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode

Reply via email to