* table formula for the second last row
@ 2023-07-24 7:21 Luca Ferrari
2023-07-24 7:38 ` Ihor Radchenko
0 siblings, 1 reply; 2+ messages in thread
From: Luca Ferrari @ 2023-07-24 7:21 UTC (permalink / raw)
To: emacs-org list
Hi all,
I've a table that is keep growing, and in the end I've added the
following to formulas:
#+TBLFM: @>$3=vsum(@3..@-1)
#+TBLFM: @>$3=round( vsum(@3..@-2)/60 )
but both overwrite the last row of the third column, while I would
like the former to be on the second last row.
Apparently I'm not able to understand how to do @> - 1, and I don't
want to place a fixed row number since the table will add new rows
over the time.
Any help is appreciated.
Thanks,
Luca
^ permalink raw reply [flat|nested] 2+ messages in thread
* Re: table formula for the second last row
2023-07-24 7:21 table formula for the second last row Luca Ferrari
@ 2023-07-24 7:38 ` Ihor Radchenko
0 siblings, 0 replies; 2+ messages in thread
From: Ihor Radchenko @ 2023-07-24 7:38 UTC (permalink / raw)
To: Luca Ferrari; +Cc: emacs-org list
Luca Ferrari <fluca1978@gmail.com> writes:
> #+TBLFM: @>$3=vsum(@3..@-1)
> #+TBLFM: @>$3=round( vsum(@3..@-2)/60 )
>
> but both overwrite the last row of the third column, while I would
> like the former to be on the second last row.
@>>$3
--
Ihor Radchenko // yantar92,
Org mode contributor,
Learn more about Org mode at <https://orgmode.org/>.
Support Org development at <https://liberapay.com/org-mode>,
or support my work at <https://liberapay.com/yantar92>
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2023-07-24 7:39 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2023-07-24 7:21 table formula for the second last row Luca Ferrari
2023-07-24 7:38 ` Ihor Radchenko
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).