Questions tagged [formula]

The tag has no usage guidance.

14 questions
22 views

Is there a way to calculate rows on a “rolling” basis?

Rolling formulas are very common in accounting, for example, carrying forward a monthly balance based on expenses. So say you had a table with month, beginning balance, fixed income, expenses, and ...
18 views

Recalculate buffer tables after field motion commands?

I would like emacs to automatically run org-table-recalculate-buffer-tables every time and only if A) cursor is in a table AND B) after a field motion command (TAB, S-TAB or RET) OR (optionally) ...
41 views

Using org-mode clock-report, how can I add a total row + cell with a formula that is automatically updated upon dblock update?

I am having trouble with using the formulas to create a cell that totals a column. Is it possible to dynamically add a line and a total cell to the bottom of clock report tables? because when I add a ...
63 views

Using an org-table formula to sum up weekly time cards

I'm filling my time cards in an org-table like below. Is there a way to fill the column Totals automatically with a formula? For the individual lines in a project task, I'd like to sum the hours ...
308 views

Make org-mode table formulas use common arithmetic precedence

Given this org-mode document: | 4 | ? | #+TBLFM: \$2=\$1/2*2 Evaluating the formulas produces (in the second cell) the surprising result 1, instead of (4/2*2=) 4. Apparently, multiplication has a ...
271 views

Org table spreadsheet recalculate all TBLFM lines

The following answer states, that one must have all recalculating formulas in one #+TBLFM line: https://emacs.stackexchange.com/a/10946/10090. Indeed, when I try the following formulas only the first ...
246 views

Org table spreadsheet use column name on left hand side

I have the following table and formulas: | | Runde | 0 | 1 | 2 | Resultat | % | |---+-------+---+---+---+----------+------------| | ! | name | | | | result | percentage | | # | ...
240 views

Number-separators in org-mode tables

I often paste org-mode tables numbers that are e.g. space-separated. Then I have to delete spaces before things like =\$2/2 work correctly. Is there a way to change "number format", e.g. plug in a ...
38 views

Re-apply table formulas on org-mode export

I'm using an org-mode file to do some filesystem monitoring. To that purpose I have a table in which I'm calling code blocks through org-sbe in the formulas. It looks like this: #+NAME: part-size #+...
48 views

Replace formula by computed value

I'd like to select a simple formula like 17+5 and replace that by the computed result, 22 in this case. And I need this to work during keyboard macro execution, to quickly process large portions of my ...
520 views

Can I use formula to manipulate text in org mode table?

I can use following code to create sum of numbers. But how can I append some text? #+TBLFM: \$4=\$2+\$1+\$3 For example | 名字 | 内容1 | 内容2 | 结果 results | |--------+--------------+...
784 views

I have a small square orgmode spreadsheet with some data in it and 2 extra columns to the right with some formulas, like average and sum. I want to add some new columns in the middle of my spreadsheet ...