emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* very long table calc expressions ?
@ 2018-06-19 17:21 Uwe Brauer
  2018-06-20  6:13 ` Thierry Banel
  2018-06-21 19:06 ` Bernt Hansen
  0 siblings, 2 replies; 14+ messages in thread
From: Uwe Brauer @ 2018-06-19 17:21 UTC (permalink / raw)
  To: emacs-orgmode



Hi

Take the following example 


#+TBLNAME: data
 | Name | Cual 1 |
 |------+--------|
 | A    | NT     |
 | B    | NT     |
 | C    | MH     |
 | D    | AP     |
 | E    | MH     |
 | F    | SS     |
 | G    | NP     |
 | H    | NP     |
 | I    | NP     |
 |      | NT     |
 |      | AP     |
 |      | AP     |
 |      | AP     |
 |      | AP     |
 |      | SB     |


#+TBLNAME: stat-final2
|    | Frequency |
|----+-----------|
| SS |         1 |
| AP |         5 |
| NT |         3 |
| SB |         1 |
| MH |         2 |
| NP |         3 |
#+TBLFM: @>$2='(length (org-lookup-all "NP" '(remote(data,@2$2..@>I$2)) nil))::@>>$2='(length (org-lookup-all "MH" '(remote(data,@2$2..@>I$2)) nil))::@>>>$2='(length (org-lookup-all "SB" '(remote(data,@2$2..@>I$2)) nil))::@>>>>$2='(length (org-lookup-all "NT" '(remote(data,@2$2..@>I$2)) nil))::@>>>>>$2='(length (org-lookup-all "AP" '(remote(data,@2$2..@>I$2)) nil))::@>>>>>>$2='(length (org-lookup-all "SS" '(remote(data,@2$2..@>I$2)) nil))


Are there any rules to break this very long expression?

Thanks

Uwe Brauer 

^ permalink raw reply	[flat|nested] 14+ messages in thread

end of thread, other threads:[~2018-06-22 17:54 UTC | newest]

Thread overview: 14+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2018-06-19 17:21 very long table calc expressions ? Uwe Brauer
2018-06-20  6:13 ` Thierry Banel
2018-06-20  9:09   ` Uwe Brauer
2018-06-20 18:28     ` Thierry Banel
2018-06-21 13:35       ` Uwe Brauer
2018-06-21 19:06 ` Bernt Hansen
2018-06-22 10:28   ` Uwe Brauer
2018-06-22 13:16     ` Bernt Hansen
2018-06-22 14:16       ` Uwe Brauer
2018-06-22 15:03         ` Jonathan Leech-Pepin
2018-06-22 15:25           ` Uwe Brauer
2018-06-22 16:48             ` Nick Dokos
2018-06-22 17:22               ` Thierry Banel
2018-06-22 17:54                 ` Uwe Brauer

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