columnview: add a formula?

columnview: add a formula?

[Uwe Brauer]

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.