Re: [O] calculate frequencies in a table with calc

[Achim Gratz]

Am 25.12.2012 13:59, schrieb Martin Gross:
> #+TBLFM: 
> @5$1=vcount(@address@hidden)::@6$1=vcount(map(<if(eq(#1,12),1,[])>,@address@hidden))
>
> 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(@address@hidden)))
for the second formula.


--
Achim.

(on the road :-)