Make calculations easier with the calculator Calculations in the columns of a Table control When a Table control contains numeric data, it may be useful to get the total of a column or count... How to create an SQL query with a calculation formula? This help page explains how to create a query with a calculation formula with the query editor.... Programming custom calculations in Table controls Automatic calculations in a Table control (AAF) Programming automatic calculations in the columns of a Table control Programming custom calculations in Table controls (prefix syntax) Programming automatic calculations in the columns of a Table control (prefix syntax) XMLResult (Function) Returns the result of a calculation XPath query. HStatCalculate (Function) Performs various statistical calculations on the file keys. <Source>.StatCalculate (Function) Performs various statistical calculations on the file keys. The Calculated control The "Calculated" control is used to perform calculations in a report...... TotalsEnabled (Property) The TotalsEnabled property enables you to: Identify the calculation method used for columns... SpreadsheetAddFormula (Function) Adds a calculation formula into a Spreadsheet control found in a window. <Spreadsheet>.AddFormula (Function) Adds a calculation formula into a Spreadsheet control found in a window. <Spreadsheet>.GetFormula (Function) Retrieves the calculation formula of a cell found in a Spreadsheet control of a window. SpreadsheetGetFormula (Function) Retrieves the calculation formula of a cell found in a Spreadsheet control of a window. TableFormulaAdd (Function) Adds a calculated row to a Table control by providing custom calculation procedures. <Pivot table>.Save (Function) Saves the result of the calculation performed in a Pivot Table control (in a file or in memory). PVTSave (Function) Saves the result of the calculation performed in a Pivot Table control (in a file or in memory). <Table>.FormulaAdd (Function) Adds a calculated row to a Table control by providing custom calculation procedures. StringToNum (Function) ... calculations on strings. <ANSI string type>.ToNum (Function) ... calculations on strings. Operations in a Select query The query editor allows you to perform operations on the values of an item...... Report based on a query Queries are used to easily select records in one or more data files......