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