diff --git a/featureshow/org-mode-teaser.org b/featureshow/org-mode-teaser.org index 1d4305a..0d949ca 100644 --- a/featureshow/org-mode-teaser.org +++ b/featureshow/org-mode-teaser.org @@ -735,24 +735,24 @@ The formular can be simplified even more by using a column formula: #+NAME: comparison-table-horizontal | | Joe | Alice | Bob | sum | -| 2012 Income June | 10 | 24 | 17 | 51 | +| Income June 2012 | 10 | 24 | 17 | 51 | | plus 20 percent | 12.0 | 28.8 | 20.4 | 60.0 | | June 2013 | 11 | 31 | 21 | | | Difference | -1.0 | 2.2 | 0.6 | 1.8 | -#+TBLFM: @>$>=vsum(@address@hidden)::@address@hidden(Income2012h, @1$$#)::@2=remote(Income2012h, @3$$#)::@address@hidden * remote(Income2012h, @3$$#);%.1f::@address@hidden@address@hidden;%.1f +#+TBLFM: @>$>=vsum(@address@hidden)::@address@hidden'(identity remote(Income2012h, @1$$#))::@2='(identity remote(Income2012h, @3$$#))::@address@hidden * remote(Income2012h, @3$$#);%.1f::@address@hidden@address@hidden;%.1f - all formulas explained in detail: - ~@>$>=vsum(@address@hidden)~ - value: ~1.8~ - last column in last row (~@>$>~) is the vector-sum (~vsum~) of column two to four of fifth row (address@hidden@5$4~) - - address@hidden@1$4=remote(Income2012h, @1$$#)~ + - address@hidden@1$4='(identity remote(Income2012h, @1$$#))~ - values: ~Joe | Alice | Bob | sum~ - column two to four of first row (address@hidden@1$4~) are copied from the corresponding fields of the first row (address@hidden) of table "Income2012h" - see also [[http://orgmode.org/worg/org-hacks.html#field-coordinates-in-formulas][Org-hacks]] for field formulas - - address@hidden(Income2012h, @3$$#)~ + - address@hidden'(identity remote(Income2012h, @3$$#))~ - values: ~2012 Income June | 10 | 24 | 17 | 51~ - the second row (address@hidden) is copied from the corresponding fields of the first row (address@hidden) of table "Income2012h"