When Vantage evaluates an aggregate UDF expression, it invokes the aggregate function once for each item in an aggregation group, passing the detail values of a group through the input arguments. To accumulate summary information, the context is retained each time the aggregate function is called.
The rules that apply to the arguments in an aggregate function call are the same as those that apply to a scalar function call. See UDF Arguments.
The result type of an aggregate UDF is based on the return type specified in the RETURNS clause of the CREATE FUNCTION statement. If the result parameter is of TD_ANYTYPE data type, see Result Data Type for information on how the return type is determined.
The default title of an aggregate UDF appears as:
UDF_name (argument_list )