Aggregate Function

Posted in Finance, Accounting and Economics Terms, Total Reads: 466

Definition: Aggregate Function

An aggregate function is a mathematical computation comprising a set of values or numbers. Aggregate functions are used profoundly in spreadsheets and databases including financial calculations. It transforms a set of values to a single value such as mean or summation of a set of numbers.

The revolution of computers has allowed aggregate functions to produce results quickly even on a large set of data. The outputs of aggregate functions are essential in various financial calculations.

Examples of aggregate function include

average() : It returns the mean or average of the values provided

sum() : It returns summation of the values provided



Looking for Similar Definitions & Concepts, Search Business Concepts

Similar Definitions from same Category: