From: Thorsten <gruenderteam.berlin@googlemail.com>
To: emacs-orgmode@gnu.org
Subject: Re: Re: org-table formulas with missing values
Date: Sun, 06 Mar 2011 23:44:59 +0100 [thread overview]
Message-ID: <86sjuzdg2c.fsf@googlemail.com> (raw)
In-Reply-To: AANLkTi=NcQ-1oPxjQ14yWju2-P+=iHBTcmC7Ai3SF8AM@mail.gmail.com
Rainer M Krug <r.m.krug@gmail.com> writes:
> On Sat, Mar 5, 2011 at 11:55 AM, Thorsten
> <gruenderteam.berlin@googlemail.com> wrote:
>> Bastien <bzg@altern.org> writes:
>>
>>> Hi Thorsten,
>>>
>>> Thorsten <gruenderteam.berlin@googlemail.com> writes:
>>>
>>>> Ok, trial and error suggests that missing values in numeric columns can
>>>> be represented as 0 in formulas, in string columns as "". Is there
>>>> something like NaN in calc/org-table?
>>>
>>> I don't know what is NaN. Can you give an example of what you're trying
>>> to achieve?
>>
>> NaN stands for NotaNumber and is usually used in statistic programs to
>> denote missing numerical values
>
> NaN ia, as you state, NotANumber, but it is NOT a missing value, for
> which the abbreviation is NA (Not Vavailable). An example for NaN
> would be 1/0 - the value is there, but it is not a number. And,
> consequently, NaN and NA can be treated separately. In general, if you
> enter values, you use NA, as you usually do not enter values which are
> not a number...
It seems there is no special variable 'na' in calc, and anyway, 'nan' is
not recognized either, but calc-info agrees with you.
nil does the job - but somehow interferes with the else-part of the
formula, that is not calculated anymore:
| day | tel- calls | change (%) |
|-----+------------+-------------------------------------------------|
| 1 | 7 | 0 |
| 2 | 2 | 2 = nil ? nil : round(((2 - 7) / 7) 100, 0) |
| 3 | 3 | 3 = nil ? nil : round(((3 - 2) / 2) 100, 0) |
| 4 | nil | nil |
| 5 | 2 | 2 = nil ? nil : round(((2 - nil) / nil) 100, 0) |
| 6 | 0 | 0 = nil ? nil : round(((0 - 2) / 2) 100, 0) |
| 7 | 3 | 3 = nil ? nil : round(((3 - 0) / 0) 100, 0) |
#+TBLFM: $3=if(@$-1=nil,nil,round((((@$-1-@-1$-1) / @-1$-1) * 100), 0)::@2$3=@2$2-@2$2
But even if nil would work, my basic question remains: if I have for
example a dynamic report were one code-block in the org file retrieves
new data frequently and stores them in a table, which has some formula
applied to it, and 0 values as well as missing values are possible, how
can I address the empty cells in the formula without confusion with
regards to the cells with 0 values?
Thorsten
next prev parent reply other threads:[~2011-03-06 22:45 UTC|newest]
Thread overview: 8+ messages / expand[flat|nested] mbox.gz Atom feed top
2011-02-26 18:32 org-table formulas with missing values Thorsten
2011-02-27 0:01 ` Thorsten
2011-02-27 11:45 ` Bastien
2011-03-05 10:55 ` Thorsten
2011-03-05 11:01 ` Rainer M Krug
2011-03-06 22:44 ` Thorsten [this message]
2011-03-06 23:03 ` suvayu ali
2011-03-08 19:18 ` Thorsten
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=86sjuzdg2c.fsf@googlemail.com \
--to=gruenderteam.berlin@googlemail.com \
--cc=emacs-orgmode@gnu.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).