emacs-orgmode
[Top][All Lists]
Advanced

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

Re: [O] Tables for attendance lists - A problem understanding TBLFM?


From: Suvayu Ali
Subject: Re: [O] Tables for attendance lists - A problem understanding TBLFM?
Date: Tue, 9 Apr 2013 02:25:19 +0200
User-agent: Mutt/1.5.21 (2012-12-30)

On Mon, Apr 08, 2013 at 06:57:53PM -0500, Gunnar Wolf wrote:
> #+CAPTION: Attendances for April
> |---------+-------------------+---+---+---+---+----+-------|
> | Account | Name              | 1 | 3 | 5 | 8 | 10 | Total |
> |---------+-------------------+---+---+---+---+----+-------|
> |    1234 | Cárdenas, Lázaro  | X |   | X | X |    |     3 |
> |    5678 | Madero, Francisco | X | X | X | X |    |     4 |
> |    1544 | Villa, Pancho     |   |   |   |   |    |     1 |
> |    0113 | Zapata, Emiliano  |   | X | X |   |    |     2 |
> |---------+-------------------+---+---+---+---+----+-------|
> | Day avg | 2.25              | 2 | 2 | 3 | 2 |  1 |  2.50 |
> |---------+-------------------+---+---+---+---+----+-------|
> #+tblfm: @address@hidden'(length 
> '($3..$7))::@6$2=vmean($3..$7);%.2f::@address@hidden'(length 
> '(@address@hidden))::@6$8=vmean(@address@hidden);%.2f

Probably not what you were looking for, why complicate things by using
Xs instead of just a numeral like 1?  If you use 1, then you can use a
column formula; maybe something like $>=sum($3..$-1).

-- 
Suvayu

Open source is the future. It sets us free.



reply via email to

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