Function group | Execute on client | Platform(s) |
---|---|---|
List | NO | All |
tot([listname,]fieldname)
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.
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