2020-10-23 Dante Catalfamo wrote:
That seems to work for the most part, but now I'm experiencing a strange
difference when evaluating. If I use a formula like
#+TBLFM:@2$3..@23$3=if($2!=0,12*$2,$3);%.2f::@24$2=vsum(@I..@II);%.2f::@24$3=vsum(@I..@II);%.2f
The column gets evaluated first,
That seems to work for the most part, but now I'm experiencing a strange
difference when evaluating. If I use a formula like
#+TBLFM:@2$3..@23$3=if($2!=0,12*$2,$3);%.2f::@24$2=vsum(@I..@II);%.2f::@24$3=vsum(@I..@II);%.2f
The column gets evaluated first, then the sum at the bottom gets
Hello,
I'm trying to create a table where the third column between two hlines is set
by a formula referencing the second column.
Here is an example:
| a | b | c |
|---+---+|
| row 1 | 12.00 | 144.00 |
| row 2 | | 23.00 |
|---+---+|
| sum |
Dante Catalfamo wrote:
In the case where I'm using this formula, there are many more rows
between @I..@II. I only used two in the example to keep the email small.
I would also be adding more rows regularly, making it slightly
impractical to be adjusting the beginning and end points of the
In the case where I'm using this formula, there are many more rows
between @I..@II. I only used two in the example to keep the email small.
I would also be adding more rows regularly, making it slightly
impractical to be adjusting the beginning and end points of the formula
every time I add or
This seems to be related to:
https://emacs.stackexchange.com/questions/15185/cant-assign-to-hline-relative-reference
There seem to be restrictions regarding hline-relative-references within
table-formulas.
If change 'I' and 'II' for 1 and 2 on the very left of the formula, it works
(keeping
Hello,
I'm trying to create a table where the third column between two hlines is set
by a formula referencing the second column.
Here is an example:
| a | b | c |
|---+---+|
| row 1 | 12.00 | 144.00 |
| row 2 | | 23.00 |
|---+---+|
| sum |