Record.CalcSums(Any [, Any,...]) Method

Version: Available or changed with runtime version 1.0.

Calculates the total of a column in a table. You specify which fields to calculate by using parameters.


[Ok := ]  Record.CalcSums(Field1: Any [, Field2: Any,...])


 Type: Record
An instance of the Record data type.

 Type: Any

[Optional] Field2
 Type: Any

Return Value

[Optional] Ok
 Type: Boolean
true if the operation was successful; otherwise false. If you omit this optional return value and the operation does not execute successfully, a runtime error will occur.


If one of the fields specified is not a SumIndexField, the operation will be unsuccessful and a runtime error will occur.

See Also

Record Data Type
Get Started with AL
Developing Extensions
CALCSUM Method (FieldRef)
AL Database Methods and Performance on SQL Server