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 Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode