| Function group | Execute on client | Platform(s) |
| List | NO | All |
avgc(listname,column[,ignore-nulls])
Returns the average value for a list column specified by listname and column. avgc() can only be used with columns defined using variables so it cannot be used with lists defined from a SQL class
If you set ignore-nulls to 1, null values are ignored and not counted. If you omit this parameter or it evaluates to zero, nulls are treated as zero values and are counted.
CalculatelResultasavgc(lList,lCol1,1)# returns the average for lCol1 not including null or zero values