emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Orgmode] how to clear computed values


From: Cecil Westerhof
Subject: [Orgmode] how to clear computed values
Date: Tue, 10 Jul 2007 20:38:49 +0200

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 <address@hidden>





reply via email to

[Prev in Thread] Current Thread [Next in Thread]