cross
New Foswiki release 2.1.6 is available with important security fixes.
Sourceforge foswiki email lists being discontinued. Subscribe to the new Foswiki announce and discuss lists at MailingLists

SHOWCALC

Operates on the result of a FormQueryPlugin query represented as a table, using a previous %QUERYTOCALC. Accepts a single, unnamed parameter:
Parameter Description
  Required; the calculation to perform
The parameter is text as required by the $CALC statement (see SpreadSheetPlugins); all operations supported by %CALC are supported by %SHOWCALC. This command behaves identical to %CALC when used following a table; it operates on the implicit table constructed by a preceding %QUERYTOCALC statement. Arbitrary many %SHOWCALC can be performed; all apply to the preceeding implicit table.

Example:
%SHOWCALC{"$ROW()"}%
returns the number of matches of a query that had been formatted as an implicit table.

See also: FormQueryPlugin, %SUMFIELD%, %FORMQUERY%, %QUERYTOCALC%, %TABLEFORMAT%, %SHOWCALC%, %MATCHCOUNT%, %SHOWQUERY%
Topic revision: r1 - 17 Nov 2009, CrawfordCurrie - This page was cached on 24 Sep 2018 - 15:33.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy