Returns the sum 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.
SumList(InputList: String,Delimiter: String,ItemType: String):Integer
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, and float. The default value is float.
SumList(1;2;3,;,Integer)
Return value is 6.