Skip to main content

 

Developing an Application

 

 

OutSystems

Aggregate a Column into a Single Value

  • Edit
    Collaborate with us
    Edit this page on GitHub
  • Sometimes displaying a single aggregated value can be more meaningful than displaying the full list of records available in the database.

    To aggregate a column into a single value, hover on the column, click Aggregate Menu and choose one of the available aggregate functions:

    • Sum: sums all the values in the column
    • Average: calculates the average of the values in the column
    • Max: finds the maximum value in the column
    • Min: finds the minimum value in the column
    • Count: counts how many rows there are in the column

    Aggregate a Column Into a Single Value

    The list of available aggregate functions depends on the data type of the column. Sum and Average are only available for numeric data types whereas textual data types (text, email, and phone number) only have the Count function available.

    • Was this article helpful?