From: Rainer Hansen <rainer.hansen@gmx.net>
To: emacs-orgmode@gnu.org
Subject: Re: How to calculate sum of property in tree?
Date: Sun, 24 Apr 2016 11:11:14 +0200 [thread overview]
Message-ID: <87inz7jrrh.fsf@gmx.net> (raw)
In-Reply-To: 87a8kkaddh.fsf@gmx.net
> Hi,
>
> I would like Emacs to calculate the price for the travel cost
> (21.90). This should be calculated as sum of the values of the property
> "Price" in the elements of the tree. How do I do that in Emacs Lisp?
I found one way to do it. I defined the COLUMNS property with %Price{+},
i.e. sum numbers in column 'Price and format result with `%.2f'
(always two decimals after point). After that I added the property
'Price' and, while cursor on 'Price', with `C-c C-c (`org-property-action')' and choosing option c
(compute) the value of 'Price' got calculated.
I added the same inline Emacs Lisp expression to the headline to include
the result (21.90) in the headline.
-------8<----------------8<-------------
* Travel cost -- src_emacs-lisp{(org-entry-get (point) "Price")} EUR
:PROPERTIES:
:COLUMNS: %Price{+;%.2f}
:Price: 21.90
:END:
** Train Eusirchen -- Bonn, src_emacs-lisp{(org-entry-get (point) "Price")} EUR
:PROPERTIES:
:Price: 7.70
:END:
** Bus Euskirchen -- Stotzheim, src_emacs-lisp{(org-entry-get (point) "Price")} EUR
:PROPERTIES:
:Price: 2.40
:END:
** Taxi Bonn, src_emacs-lisp{(org-entry-get (point) "Price")} EUR
:PROPERTIES:
:Price: 11.80
:END:
-------8<----------------8<-------------
Any ideas on how to improve that solution?
Rainer Hansen <rainer.hansen@gmx.net> writes:
>
> ----------------------------------------------
> * Travel cost -- 21.90 EUR
>
> ** Train Eusirchen -- Bonn, src_emacs-lisp{(org-entry-get (point) "Price")} EUR
> :PROPERTIES:
> :Price: 7.70
> :END:
> ** Bus Euskirchen -- Stotzheim, src_emacs-lisp{(org-entry-get (point) "Price")} EUR
> :PROPERTIES:
> :Price: 2.40
> :END:
>
> ** Taxi Bonn, src_emacs-lisp{(org-entry-get (point) "Price")} EUR
> :PROPERTIES:
> :Price: 11.80
> :END:
> ----------------------------------------------
>
> Thanks!
>
> Rainer
prev parent reply other threads:[~2016-04-24 9:11 UTC|newest]
Thread overview: 2+ messages / expand[flat|nested] mbox.gz Atom feed top
2016-04-23 9:22 How to calculate sum of property in tree? Rainer Hansen
2016-04-24 9:11 ` Rainer Hansen [this message]
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=87inz7jrrh.fsf@gmx.net \
--to=rainer.hansen@gmx.net \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this external index
https://git.savannah.gnu.org/cgit/emacs.git
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.