Which function cannot be used on an integer data type in an Aggregate?

In the context of using aggregate functions in OutSystems, the median is not typically applicable to integer data types in the same way that the other functions are.

The count function is used to tally the number of occurrences of values in a dataset, which applies to any data type, including integers. The average function calculates the mean value of a set of numbers, and it is also valid for integer data types as it can compute the average value regardless of whether the inputs are integers. The max function identifies the highest value in a set of integers, which is straightforward as it directly relates to numeric comparison.

However, the median is a statistical measure that requires sorting a dataset and finding the middle value or the average of the two middle values in the case of an even number of entries. In many aggregate frameworks, including OutSystems, the median function is often not implemented for certain data types or may require special handling that might not directly apply to integer data types. This distinction sets the median apart from the other functions listed, as it may not be supported directly or efficiently in the context of aggregates for integers.