[Top][All Lists]
[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>
- [Orgmode] how to clear computed values,
Cecil Westerhof <=
- Re: [Orgmode] how to clear computed values, Carsten Dominik, 2007/07/11
- Re: [Orgmode] how to clear computed values, Cecil Westerhof, 2007/07/11
- Re: [Orgmode] how to clear computed values, Carsten Dominik, 2007/07/11
- Re: [Orgmode] how to clear computed values, Cecil Westerhof, 2007/07/11
- Re: [Orgmode] how to clear computed values, Carsten Dominik, 2007/07/11
- Re: [Orgmode] how to clear computed values, Cecil Westerhof, 2007/07/11
- Re: [Orgmode] how to clear computed values, Carsten Dominik, 2007/07/11
Re: [Orgmode] how to clear computed values, Cecil Westerhof, 2007/07/11