tot()

Function group Execute on client Platform(s)
List NO All

Syntax

tot([listname,]fieldname)

Description

Returns the total of the stored values of fieldname in a list specified by listname.

The fieldname argument must be a field stored in the list, not a constant or expression. If the listname argument is not specified the current list is used. This function does not work for table based lists. If fieldname is not a numeric field, all values are converted to their numeric equivalents before being accumulated.

Example

Calculate lResult as  tot(lList,lCol1)
# returns total of all lCol1 field values stored in the list lList

Calculate lResult as tot(lCol1)
# returns total of all lCol1 field values stored in current list

Calculate lResult as tot(#LSEL)
# returns total number of selected lines in the current list