Am 25.12.2012 13:59, schrieb Martin Gross:
#+TBLFM: @5$1=vcount(@I..@II)::@6$1=vcount(map(<if(eq(#1,12),1,[])>,@I..@II))
With the first formula (@5$1) everything inside and outside the
brackets is counted, but with the second (@6$1), where I am asking for
the frequency of 12, only what is outside the brackets is considered.
How could I also include what is inside the brackets, so I get 4?
The Calc manual tells you that vcount flattens nested vectors, vmap doesn't.
Try @6$1=vcount(map(<if(eq(#1,12),1,[])>,vflat(@I..@II)))
for the second formula.
--
Achim.
(on the road :-)
