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 15 Dec 2018 - 16:22.

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