All of the arguments of these functions (x, y, z, s, and w) are expressions. Series and array subranges are allowed in any argument requiring a series or array (without subscripts).

DPL Excel Action
@avg(x,y,z,...)AVERAGE(x,y,z,...) The average of the non-empty (non-null) expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@count(x,y,z,...)COUNT(x,y,z,...) The number of non-empty (non-null) expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@max(x,y,z,...)MAX(x,y,z,...) The maximum of the expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@min(x,y,z,...)MIN(x,y,z,...) The minimum of the expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@std(x,y,z,...)STDEV(x,y,z,...) The standard deviation of the non-empty expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@sum(x,y,z,...)SUM(x,y,z,...) The sum of the expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@var(x,y,z,...)VAR(x,y,z,...) The variance of the non-empty (non-null) expressions in the argument list. The argument list may include the unsubscripted names of series or arrays.
@sumproduct(array1, array2, array3,...)SUMPRODUCT(array1, array2, array3,...) Multiplies corresponding components in the given arrays, and returns the sum of those products.

DPL treats null elements in the argument list in the same way a spreadsheet treats empty (null) cells. For instance, the @count() function will count the number of elements in an argument list, but will omit null elements from the count.

Notes: This information is subject to change. New functions are added from time to time. Contact technical support for the latest compatibility information.

Versions: DPL Professional, DPL Enterprise, DPL Portfolio