Re: [O] problem with empty column

2018-01-06 Thread Eric S Fraga
On Saturday, 6 Jan 2018 at 09:37, Uwe Brauer wrote: > The column of reference is E1 per default, which is the second one. The Ah, okay, I understand now. Thanks. I see that you have been given a solution elsewhere using vmean but you could also consider adding "N" to the expression (i.e. after

Re: [O] problem with empty column

2018-01-06 Thread Uwe Brauer
>>> "Michael" == Michael Brand 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 |

Re: [O] problem with empty column

2018-01-06 Thread Uwe Brauer
>>> "Eric" == Eric S Fraga writes: > On Friday, 5 Jan 2018 at 13:44, Uwe Brauer wrote: >> What I meant is this. > I understood what you meant and your code is working properly. You > are checking the second column which is the column labelled E1, not > the

Re: [O] problem with empty column

2018-01-05 Thread Eric S Fraga
On Friday, 5 Jan 2018 at 13:44, Uwe Brauer wrote: > What I meant is this. I understood what you meant and your code is working properly. You are checking the second column which is the column labelled E1, not the one labelled E2 which is actually the third column... change your if statement to

Re: [O] problem with empty column

2018-01-05 Thread Michael Brand
Hi Uwe On Fri, Jan 5, 2018 at 1:44 PM, Uwe Brauer wrote: > But fails if there is a row like this > > | Name | E1 | E2 | E3 | E4 | Res | > |+++++-| > | Entry1 ||||| NP | > | Entry2 | 10 | 20 | 30 | 40 | 10 | > | Entry3 | 10 ||

Re: [O] problem with empty column

2018-01-05 Thread Uwe Brauer
"Eric" == Eric S Fraga writes: > On Friday, 5 Jan 2018 at 09:28, Uwe Brauer wrote: [...] >> The last row behaves strangely the cell in the second >> column is *not* empty but the cell in the third one is, >> nevertheless the cell in the last column contains

Re: [O] problem with empty column

2018-01-05 Thread Eric S Fraga
On Friday, 5 Jan 2018 at 09:28, Uwe Brauer wrote: [...] > The last row behaves strangely the cell in the second column is *not* > empty but the cell in the third one is, nevertheless the cell in the > last column contains the string nan, which I don't understand. But the second column is *not*

Re: [O] problem with empty column

2018-01-05 Thread Loris Bennett
Uwe Brauer writes: > Hi > > Consider please the following table > > > > | Name | E1 | E2 | E3 | E4 | Res | > |+++++-| > | Entry1 ||||| NP | > | Entry2 | 10 | 20 | 30 | 40 | 10 | > > #+TBLFM: $6=if("$2" == "nan" ,