April 2017
Intermediate to advanced
706 pages
17h 8m
English
The CALCSUMS function is conceptually similar to CALCFIELDS for the calculation of Sums only. However, CALCFIELDS operates on FlowFields and CALCSUMS operates directly on the record where the SumIndexFields are defined for the keys. That difference means that we must specify the proper key plus any filters to apply when using CALCSUMS (the applicable key and filters to apply are already defined in the properties for the FlowFields).
The syntax for CALCSUMS is as follows:
[ BooleanField := ] Record.CALCSUMS ( SumIndexField1 [,SumIndexField2] ,...)
Prior to a statement of this type, we should specify a key that has the SumIndexFields defined (in order to maximize the probability of good performance). Before executing the ...
Read now
Unlock full access