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.
Syntax
[Ok := ] Record.CalcSums(Field1: Any [, Field2: Any,...])
Parameters
Record
Type: Record
An instance of the Record data type.
Field1
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.
Remarks
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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for