Returns the average of the items in a list, ignoring blank items. Returns a blank string if the list contains an item not of the specified item type.
AvgList(InputList:String,Delimiter:String,ItemType:String):String
InputList specifies the list to use.
Delimiter is the character to use to delineate items in the string list. Supported special characters:
[comma]
[space]
[tab]
Note: | You must use the name of the delimiter (not the character) and include brackets around the name. |
ItemType indicates the expected item data type for list members. Valid values: integer, float, and datetime. The default value is float.
AvgList(1;2;3,[comma],Integer)
Return value is 2.