From mboxrd@z Thu Jan  1 00:00:00 1970
From: Achim Gratz <Stromeko@Nexgo.DE>
Subject: Re: calculate frequencies in a table with calc
Date: Wed, 26 Dec 2012 09:28:55 +0100
Message-ID: <kbecft$a5$1@ger.gmane.org>
References: <CAJkULmn6Xw9dqS7huWoQPESCLOh3PavF=WnCWfbsaU7RoeugGQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:33828)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1TnmMM-0004rV-Uy
	for emacs-orgmode@gnu.org; Wed, 26 Dec 2012 03:29:09 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1TnmMM-0005Jd-0g
	for emacs-orgmode@gnu.org; Wed, 26 Dec 2012 03:29:06 -0500
Received: from plane.gmane.org ([80.91.229.3]:60484)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1TnmML-0005JZ-Px
	for emacs-orgmode@gnu.org; Wed, 26 Dec 2012 03:29:05 -0500
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1TnmMW-0002a3-46
	for emacs-orgmode@gnu.org; Wed, 26 Dec 2012 09:29:16 +0100
Received: from p5b14dcdc.dip.t-dialin.net ([91.20.220.220])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Wed, 26 Dec 2012 09:29:16 +0100
Received: from Stromeko by p5b14dcdc.dip.t-dialin.net with local (Gmexim 0.1
	(Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Wed, 26 Dec 2012 09:29:16 +0100
In-Reply-To: <CAJkULmn6Xw9dqS7huWoQPESCLOh3PavF=WnCWfbsaU7RoeugGQ@mail.gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

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 :-)