[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [O] sum up variables from different org-mode tables

From: Michael Brand
Subject: Re: [O] sum up variables from different org-mode tables
Date: Mon, 19 Nov 2012 14:50:15 +0100

Hi Martin

On Mon, Nov 19, 2012 at 12:54 PM, Martin Gross <address@hidden> wrote:
> Just one point is not yet optimum to me: I do not have just 2 tables,
> but hundreds.  It would be hard and not very clean to add them all one
> by one.  Do you know if it there is a better way to reference remote
> tables?  For example telling org-mode to search data from all tables
> but "this" one?

I don’t know a way to tell Org “all other tables in this file”.

And this:

On Fri, Nov 16, 2012 at 4:16 PM, Michael Brand
<address@hidden> wrote:
>    A nice solution for variant 2 would be if
>    @address@hidden = remote(A, @>>$$#) :: @address@hidden = remote(B, @>>$$#)
>    could be simplified to
>    @address@hidden = remote($8, @>>$$#)

is only a partial solution for you because - although moved from the
formula to the result table - the table enumeration is still

But if it’s just summing up disjoint sets hierarchically you might
consider column view with “ Column attributes” from the manual
to show the sums for each heading, like:

#+COLUMNS: %20ITEM %6In_num{+;%6d} %6In_EUR{+;%6.2f} %6Out_num{+;%6d}
* total
** Institution A
*** In
**** Title P
     :In_num:   1
     :In_EUR:   45
*** Out
**** Title A
     :Out_num:   1
     :Out_EUR:   15
**** Title B
     :Out_num:   2
     :Out_EUR:   28
** Institution B
*** In
**** Title Q
     :In_num:   1
     :In_EUR:   24
*** Out
**** Title C
     :Out_num:   2
     :Out_EUR:   31

Unfortunately formatting takes place only for calculations and not for
the raw source values which for me is at least a missing feature.


reply via email to

[Prev in Thread] Current Thread [Next in Thread]