emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* columnview: add a formula?
@ 2022-07-24  7:41 Uwe Brauer
  0 siblings, 0 replies; only message in thread
From: Uwe Brauer @ 2022-07-24  7:41 UTC (permalink / raw)
  To: emacs-orgmode


Hi


I have the following setting
#+begin_src 
* Everything
  :PROPERTIES:
  :COLUMNS:  %TODO  %ITEM %Cash %Card
  :END:

** WAIT Hotel
   :PROPERTIES:
   :Cash: 100
   :Card:  200
   :Result:
   :END:          

** WAIT Flight
   :PROPERTIES:
   :Cash: 300
   :Card:  200
   :Result:
   :END:          


#+BEGIN: columnview :maxlevel 2 :skip-empty-rows t :hlines 1 :indent nil  :format "%5TODO(Status) %5ITEM %4Cash(Cash) %5Card(Card) %5Result(Result)"
| Status | ITEM   | Cash | Card | Result |
|--------+--------+------+------+--------|
| WAIT   | Hotel  |  100 |  200 |        |
| WAIT   | Flight |  300 |  200 |        |
#+END:
#+end_src


However I would like to have result, the last column to be calculated by
summing so something like this

#+begin_src 
#+BEGIN: columnview :maxlevel 2 :skip-empty-rows t :hlines 1 :indent nil  :format "%5TODO(Status) %5ITEM %4Cash(Cash) %5Card(Card) %5Result(Result)"
| Status | ITEM   | Cash | Card | Result |
|--------+--------+------+------+--------|
| WAIT   | Hotel  |  100 |  200 |    300 |
| WAIT   | Flight |  300 |  200 |    500 |
#+TBLFM: $5=$3+$4;f2
#+END:

#+end_src

Any idea how to achieve this automatically?

regards

Uwe Brauer 
-- 
I strongly condemn Putin's war of aggression against the Ukraine.
I support to deliver weapons to Ukraine's military. 
I support the ban of Russia from SWIFT.
I support the EU membership of the Ukraine. 



^ permalink raw reply	[flat|nested] only message in thread

only message in thread, other threads:[~2022-07-24  7:44 UTC | newest]

Thread overview: (only message) (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2022-07-24  7:41 columnview: add a formula? Uwe Brauer

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).