emacs-orgmode
[Top][All Lists]
Advanced

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

Re: [O] problem with empty column


From: Uwe Brauer
Subject: Re: [O] problem with empty column
Date: Sat, 06 Jan 2018 09:43:45 +0100
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/26.0.50 (gnu/linux)

>>> "Michael" == Michael Brand <address@hidden> writes:

Hi Michael
   >  if(typeof(vmean($1..$7)) == 12, string(""), vmean($1..$7); E

This is precisely what I was looking for, thanks a lot. I meanwhile
circumvent the problem by

| Name   | E1 | E2 | E3 | E4 | Pre | Res |
|--------+----+----+----+----+-----+-----|
| Entry1 |    |    |    |    |   0 |  NP |
| Entry2 | 10 | 20 | 30 | 40 | 100 |  10 |
| Entry3 | 10 |    | 20 | 30 |  60 |   6 |
#+TBLFM: $6=$2+$3+$4+$5::$7=if("$2" == "nan", string("NP"),$6/10);E


But your solution is much more elegant.




reply via email to

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