emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: Steve Dowe <stephen.dowe@gmail.com>
To: emacs-orgmode@gnu.org
Subject: Basic question re. spreadsheet function
Date: Thu, 9 Jan 2014 10:13:07 +0000	[thread overview]
Message-ID: <CAEvO2fcAStuAnvU0Xs2k--uzK+jLhHh+x2qkxuQwRwRTVUYX5g@mail.gmail.com> (raw)

[-- Attachment #1: Type: text/plain, Size: 1134 bytes --]

Hi all,

I'm testing out whether I can use a table in org as a project status
tracker.  In col 6, I have the value of the project (e.g. 162.50) and in
col 9, the status (e.g. quoted, approved, invoiced, closed, etc.)

I would like to see, at a glance, what the value of quoted work is, so I'm
currently doing this in col 12 (pasted from formula editor):

# Column Formulas
$12 = if($9=quoted,$6,0)

( Col 9 in this instance contains "closed" and Col 6 contains 162.50. )

This formula results in the text

 closed = quoted ? 162.5 : 0

being displayed in col 12.  However, in another row where the col 9 does
have the text "quoted", I get pretty much the result I'm looking for, e.g.
"400." will appear in col 12 where I have 400.00 in col 6.

In the instance where the if test proves false, I would like a zero or
nothing appearing.  The intention is to sum this column in a footer row.

I have consulted
http://orgmode.org/manual/Formula-syntax-for-Calc.html#Formula-syntax-for-Calcbut
it contains a dead link (
http://orgmode.org/calc/Logical-Operations.html#Logical-Operations) -
making it harder to RTFM :-)

Thanks,
-- 
  Steve

[-- Attachment #2: Type: text/html, Size: 1663 bytes --]

next             reply	other threads:[~2014-01-09 10:13 UTC|newest]

Thread overview: 5+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2014-01-09 10:13 Steve Dowe [this message]
2014-01-09 14:04 ` Basic question re. spreadsheet function Nick Dokos
2014-01-09 17:51   ` Steve Dowe
2014-01-09 15:36 ` Michael Brand
2014-01-09 17:49   ` Steve Dowe

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=CAEvO2fcAStuAnvU0Xs2k--uzK+jLhHh+x2qkxuQwRwRTVUYX5g@mail.gmail.com \
    --to=stephen.dowe@gmail.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

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).