# 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
```al
[Ok := ]  Record.CalcSums(Field1: Any [, Field2: Any,...])
```
## Parameters
Record
Type: record-data-type
An instance of the record-data-type data type.
Field1
Type: ../any/any-data-type
*[Optional] Field2*
Type: ../any/any-data-type
## Return Value
*[Optional] Ok*
Type: ../boolean/boolean-data-type
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
See ../fieldref/fieldref-calcsum-method.
## Related information
record-data-type
Get Started with AL<../../devenv-get-started>
Developing Extensions<../../devenv-dev-overview>
../fieldref/fieldref-calcsum-method
../../../administration/optimize-sql-al-database-methods-and-performance-on-server

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/record/record-calcsums-method, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/developer/methods-auto/record/record-calcsums-method/
