How to calculate a column sum after a table

Q: When using EditTable plugin, the rows will be added at the bottom, so that is not a good place to show a column sum. The documentation of the SpreadsheetPlugin tells how to address cells in a preceding table but does not tell how to address the last row, or how to refer to a column as a whole.

A: It appears that after the table, $ROW() refers to the last column of the preceding table. Thus the following appears to work (for counting the sum of the column 4 excluding the title row):

     %CALC{ "$SUM(R2:C4..R$ROW():C4)" }%
-- KimmoKoskenniemi - 11 Jan 2008
Topic revision: r1 - 2008-01-11 - KimmoKoskenniemi
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback