Matthew Lundin <m...@imapmail.org> writes:
> Eric,
>
> Thanks so much. The updated org-collector works beautifully. This is a
> very nice way to perform calculations on subsets of data. I don't
> suppose there's any chance of generating a table that contains only
> the items in the subset (e.g., only items in which string= spendtype
> "food")?
>
Hi Matthew,
Good idea. I've added a :conds parameter which can do just that, see
the example below. Notice that :conds should be a list of tests, not
just one single test, if this proves awkward it would be easy to add
a :cond parameter which doesn't require a list.
One issue with this setup, is that it's not clear what a stable way
would be to specify the #+TBLFM line. Since the size of the table could
vary the field in which the sum should be placed could move around.
With the table below a #+TBLFM line like this
#+TBLFM: @II+1$2=vsum(@i+...@ii-1)
would work, but currently org-table does not allow the @I style
references before the = sign in the table formula. I wonder if this
would be hard difficult to change?
Thanks -- Eric
* Example
#+BEGIN: propview :id "december" :conds ((string= spendtype "food")) :cols
(ITEM amount)
| "ITEM" | "amount" |
|----------------------------------+----------|
| "Grocery Store [2008-12-01 Mon]" | 56.77 |
| "Restaurant [2008-12-08 Mon]" | 30.67 |
|----------------------------------+----------|
| | 87.44 |
#+TBLFM: @4$2=vsum(@i+...@ii-1)
#+END:
** December Spending
:PROPERTIES:
:ID: december
:END:
*** Week One
**** Grocery Store [2008-12-01 Mon]
:PROPERTIES:
:amount: 56.77
:spendtype: food
:END:
**** Athletic club [2008-12-02 Tue]
:PROPERTIES:
:amount: 75.00
:spendtype: health
:END:
*** Week Two
**** Restaurant [2008-12-08 Mon]
:PROPERTIES:
:amount: 30.67
:spendtype: food
:END:
_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
