ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage functions / Controls, pages and windows / Table functions
  • Conditions for adding the row containing the custom calculation formula
  • Recalculating data
  • Customizing the calculation row
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Adds a calculated row to a Table or TreeView Table control by providing custom calculation procedures.
Example
TableFormulaDeleteAll(TABLE_MaTable)
nLigne is int
nLigne = TableFormulaAdd(TABLE_MaTable.COL_Num, "Moyenne positive", ProcInit, ProcAjout, ProcFin)
// Changement de la couleur de fond de la ligne du calcul personnalisé
COL_Num[nLigne].CouleurFond = LightRed

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

INTERNAL PROCEDURE ProcAjout(Accumulateur, ValeurCol) 
	// Ignore les négatifs ou NULL
	IF (ValeurCol <= 0) RETURN Accumulateur
	nCompteur++
	RETURN Accumulateur + ValeurCol
END
INTERNAL PROCEDURE ProcFin(Accumulateur) 
	IF nCompteur = 0 THEN RETURN 0
	// Calcul de la moyenne
	RETURN  Accumulateur/nCompteur
END
nLigne2 is int
nLigne2 = TableFormulaAdd(TABLE_ChampTable.COL_Heure, "Durée moyenne", Null, ...
			DuréeMoyenne_Itération, DuréeMoyenne_Fin)

INTERNAL PROCEDURE DuréeMoyenne_Itération(Accumulateur, ValeurCol)
	RETURN Accumulateur + [TAB] + ValeurCol
END

INTERNAL PROCEDURE DuréeMoyenne_Fin(Accumulateur)
	nSomme is 8-byte int
	nNbValides is int
	FOR EACH STRING sValeur OF Accumulateur SEPARATED BY TAB
		IF TimeValid(sValeur) THEN
			nSomme += TimeToInteger(sValeur)
			nNbValides++
		END
	END
	RETURN TimeToString(IntegerToTime(nSomme/nNbValides), "HH:MM:SS")
END
Syntax
<Result> = TableFormulaAdd(<Column> , <Calculation caption> , <Initialization> , <Iteration> , <Ending>)
<Result>: Integer
Index of the row containing the formula.
<Column>: Control name
Name of column into which the formula will be added.
If this parameter corresponds to an empty string (""), the column to which the current process belongs will be used.
<Calculation caption>: Character string
Caption of the additional row where the calculation will be displayed.
If this caption does not exist, the row will be created.
If this caption exists but not for the specified column, the calculation is displayed in the existing row but for the specified column.
If this caption exists for the specified column, a WLanguage error occurs.
<Initialization>: Procedure name or NULL
  • Name of the WLanguage procedure ("callback") called to initialize the formula. This procedure has the following format:
    PROCEDURE <Procedure name> ()
    // your code

    RETURN <Initialization value Accumulator>

    where <Initialization value Accumulator> is the return value for the first iteration of the calculation.
  • NULL if the formula requires no initialization process.
<Iteration>: Procedure name or NULL
  • Name of the WLanguage procedure ("callback") called for each iteration of the formula (each row of the Table control). This procedure has read-only access to the columns of each row. This procedure has the following format:
    PROCEDURE <Procedure name>(<Accumulator>, <Column value>)
    // Called for each row in the Table control
    // Your code

    RETURN <New value Accumulator>

    where:
    • <Accumulator> is the value coming from the previous calculation (initialization or previous iteration).
    • <Column value> is the value of the current column used to calculate this iteration.
    • <New value Accumulator> is the new value to return for the next iteration or at the end of calculation.
  • NULL if the formula requires no iteration process.
<Ending>: Character string
  • Name of the WLanguage procedure ("callback") called to end the formula. This procedure has the following format:
    PROCEDURE <Procedure name>  (<Accumulator>)
    // your code

    RETURN <End value Accumulator>

    where:
    • <Accumulator> is the value coming from the previous calculation (initialization or previous iteration).
    • <End value Accumulator> is the return value that corresponds to the end value of the calculation.
  • NULL if the formula requires no ending process.
Remarks

Conditions for adding the row containing the custom calculation formula

  • If the calculation named <Calculation caption> does not exist in the Table control, a new calculation row is added below the Table control (after the existing calculations).
  • If a calculation named <Calculation caption> was already defined for another column, the calculation is displayed for the specified column in the existing calculation row.
  • If a calculation named <Calculation caption> was already defined for the same column, a WLanguage error occurs.
  • Only 5 custom calculation rows can be added.
Note: This function can be used:
  • on the columns of a data-bound Table or TreeView Table control.
  • on the columns of a Table or TreeView Table control populated programmatically.

Recalculating data

The custom calculation rows are automatically recalculated as soon as the content of the 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).

Customizing the calculation row

The following syntax is used to customize the added row (caption, color, font, height, ...):
<Table control>[Row number].<Property> = <New value>
where <Property> can correspond to one of the properties that can be used on a column of a Table control. For more details, see Programming custom calculations in Table controls.
Business / UI classification: UI Code
Component: wd300obj.dll
Minimum version required
  • Version 22
This page is also available for…
Comments
Cascading calculations
To have cascading values calculated in a table using TableFormulaAdd() the data fill must be "Loaded in memory" otherwise it will not calculate and you will see only zeroes (0) in the calculated column values.
This is not indicated in this help page so, I decided to point it out.
JoeData
17 Mar. 2021

Last update: 06/13/2025

Send a report | Local help