I have a table like:
|---------+---------+---------+--------+-------+----------+--------|
| kmstand | km's | prijs/l | liters | prijs | prijs/km | km/l |
|---------+---------+---------+--------+-------+----------+--------|
| 155111 | 0 | | | 0.00 | -0.000 | 0.000 |
| 156146 | 1035 | 102.2 | 62.25 | 63.62 | 6.147 | 16.627 |
| | -156146 | | | 0.00 | -0.000 | 0.000 |
|---------+---------+---------+--------+-------+----------+--------|
#+TBLFM: $2='(and @-1$-1 $1 (- $1 @-1$-1));N::$5='(and $3 $4 (/ (* $3
$4) 100));N%.2f::$6='(and $2 $5 (/ (* $5 100) $2));N%.3f::$7='(and $2 $4 (/ $2
$4));N%.3f
When there is nothing to display, there is now a '0' displayed, but I
would prefer it to be empty. Is this possible?
Also, why is prijs/km displayed as '-0.000'?
And why is the last field of km's displayed as '-156146'? I expected
'0'.
--
Cecil Westerhof <[EMAIL PROTECTED]>
_______________________________________________
Emacs-orgmode mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
