Re: [O] Can this table formula be done more efficient

[Cecil Westerhof]

2014-06-08 13:53 GMT+02:00 Nick Dokos <address@hidden>:

Cecil Westerhof <address@hidden> writes:

> At the moment I am using the following formula:
>     #+TBLFM: @<<$4..@>>$4 = $2 - $3 :: @>$2=vsum(@<<$2..@>>$2) :: @>$3=vsum(@<<$3..@>>$3) :: @>$4=vsum(@<<$4..@>>$4)
>
> This does what I want, but there are two things that could be improved.
>
> - The second, third and fourth formula do exactly the same, only on different columns. Could this be rewritten to one formula?
>

--8<---------------cut here---------------start------------->8---
#+TBLFM: @<<$4..@>>$4 = $2 - $3 :: @>$2..$4=vsum(@<<$0..@>>$0)
--8<---------------cut here---------------end--------------->8---

​Works like a charm. Thanks.

​

 

​​

See

​​

(info "(org) References")

​I should study that more diligently.

--
Cecil Westerhof