Implementation

• the name of the column taken into account for the calculation.
• the caption of the row that displays the calculation in the Table control. If this caption does not exist, the row will be created. If this caption exists, the calculation will be displayed in the requested column.
• the name of three procedures. These procedures are used to:
  • initialize the calculation,
  • to perform a calculation for each row of the Table control,
  • perform the final calculation if necessary.

TABLE_MyTable.FormulaDeleteAll()
nRow is int
nRow = TABLE_MyTable.COL_Num.FormulaAdd("Positive mean", ProcInit, ProcAdd, ProcEnd)
// Change the background color of the row for custom calculation
COL_Num[nRow].BackgroundColor = LightRed

nCounter is int
INTERNAL PROCEDURE ProcInit() 
	nCounter = 0
	RETURN 0
END

INTERNAL PROCEDURE ProcAdd(Accumulator, ColValue) 
	// Ignores the negative numbers or NULL
	IF (ColValue <= 0) RETURN Accumulator
	nCounter++
	RETURN Accumulator + ColValue
END
INTERNAL PROCEDURE ProcEnd(Accumulator) 
	IF nCounter = 0 THEN RETURN 0
	// Calculate the mean
	RETURN Accumulator/nCounter
END

• The custom calculation rows are automatically recalculated as soon as the content of the Table or TreeView Table control changes.
  Tip: the iteration procedure is called for each line: it is recommended not to perform calculations too slowly (for example, to avoid database accesses).
• The TotalsEnabled property does not allow or forces automatic or custom calculations in a Table control.
• If the DisplayEnabled property is used on the Table control and is set to False, the column calculations are not updated.
• The following syntax is used to retrieve the value of the custom calculation for a column:
  
  <Table control>.<Column name>[Row number]
  where <Row number> is the row index returned by <Table>.FormulaAdd.

Position of calculation row

1. Go to the "General" tab of the Table control (to do so, select the name of the Table control and click "General").
2. Specify the location of totals. To display the results:
   • in one or more rows directly added after the last control row, check "In the table, after the last row".
     These rows are visible:
     • at the bottom of the Table control if the control includes no vertical scrollbar.
     • when the vertical scrollbar is located at the very bottom if the Table control includes a vertical scrollbar.
   • below the Table control, check "Below the table".
     These rows are always visible.
   • you also have the ability to perform column calculations without displaying them ("No display" option).
3. Validate the Table control description window.

Customizing the calculation row

• the added row by using the following syntax:
  
  <Table control>[Row number].<Property> = <New value>
• the cell containing the result by using the following syntax:
  
  <Table control>.<Column name>[Row number].<Property> = <New value>
  
  Note: the first column contains the calculation label, if any.

• <Row number> is the row index returned by <Table>.FormulaAdd.
• <Property> can correspond to one of the following properties:
  

  BackgroundColor	Used to find out and modify the background color of a calculation cell.
  Caption	Used to find out and modify the caption of the row containing a calculation cell.
  Color	Used to find out and modify the color of the text displayed in a calculation cell.
  Font	Allows you to find out and modify the font used in a calculation cell.
  FontBold	Used to find out and modify the "Bold" attribute for the column elements.
  FontCondensed	Used to find out whether the characters of column elements are condensed or not, and to condense (or not) the characters of column elements.
  FontExtended	Used to find out whether the characters of column elements are extended or not, and to extend (or not) the characters of column elements.
  FontItalic	Used to find out and modify the "Italic" attribute for the column elements.
  FontLarge	Used to find out whether the characters of column elements are enlarged or not, and to enlarge (or not) the characters of column elements.
  FontName	Used to find out and modify the font used for the column elements.
  FontSize	Used to find out and modify the size of the font used for the column elements.
  FontStrikeOut	Used to find out and modify the "StrikeOut" attribute for a calculation cell.
  FontUnderlined	Used to find out and modify the "Underline" attribute for the column elements.
  Height	Used to find out and modify the height of a calculation cell.
  Name	Used to find out the name of a calculation cell.
  Note	Used to find out and modify the notes associated with a calculation cell.
  State	Gets and changes the display state of the row containing the calculation cell.
  Visible	Used to find out whether a column is visible and to make a column visible/invisible.
  Width	Used to find out and modify the width of a calculation cell.

Deleting the custom calculation rows

Export via the AAF (Automatic Application Features) of Table control

Export via the WLanguage functions