From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Sub-totals
Date: Thu, 20 Feb 2014 08:55:59 +0100
Message-ID: <CALn3zoiQayDS+tNm00rUfGgfm9FfM1NNGtnosnhy_kyUfzTe4A@mail.gmail.com>
References: <CAG-LmmC4-3f8UN+vQn3Hg7vAc51Qsv2m-L4or8DN0ZdmmoYB+Q@mail.gmail.com>
	<CALn3zoi0hx=7CFPC1p+0ctzhYJ7w+n1-p4hvvBxPKLBxd4u6-Q@mail.gmail.com>
	<CAG-LmmBU8V+dxH0g8ROqetjU+ZyzScN92Bks_+JXjFGUUnnndQ@mail.gmail.com>
	<CALn3zohYS2i+=1okH=6pyBfBRYGhOmLbWaQKj1TJZnVsGM_wFA@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:47137)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1WGOUE-0002eq-CF
	for emacs-orgmode@gnu.org; Thu, 20 Feb 2014 02:56:03 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1WGOUD-0002ld-Ls
	for emacs-orgmode@gnu.org; Thu, 20 Feb 2014 02:56:02 -0500
Received: from mail-pa0-x22a.google.com ([2607:f8b0:400e:c03::22a]:46533)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1WGOUD-0002lX-D7
	for emacs-orgmode@gnu.org; Thu, 20 Feb 2014 02:56:01 -0500
Received: by mail-pa0-f42.google.com with SMTP id kl14so1589232pab.1
	for <emacs-orgmode@gnu.org>; Wed, 19 Feb 2014 23:56:00 -0800 (PST)
In-Reply-To: <CALn3zohYS2i+=1okH=6pyBfBRYGhOmLbWaQKj1TJZnVsGM_wFA@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: Cecil Westerhof <cldwesterhof@gmail.com>
Cc: Nick Dokos <ndokos@gmail.com>, Org Mode <emacs-orgmode@gnu.org>

Hi Cecil

On Sun, Feb 16, 2014 at 10:06 AM, Michael Brand
<michael.ch.brand@gmail.com> wrote:

> #+TBLFM: @>$2 = vsum(@II..@>>) :: $3 = if(vlen(@-I$2..@0$2) == vlen(@-I$2..@+I$2), vsum(@-I$2..@+I$2) +.0, string("")); EN f-1 :: @>$3 = string("")

I should have simplified the condition in "if" to

#+TBLFM: @>$2 = vsum(@II..@>>) :: $3 = if(vlen(@0..@+I) == 1,
vsum(@-I$2..@+I$2) +.0, string("")); EN f-1 :: @>$3 = string("")

It's now also in the ERT.

Michael