What do Calculated Attributes in Aggregates allow you to do?

Calculated Attributes in Aggregates are pivotal for enhancing data manipulation within OutSystems applications. They allow developers to create new attributes based on the values of existing attributes, thus enabling complex data transformations and computations right at the data retrieval stage. This feature makes it possible to derive additional insights without having to modify the underlying data structure or execute additional queries.

By leveraging existing attribute values, you can create new calculated fields that can be used directly in your application. This means you can create attributes that represent aggregates, like sums or averages, or conditional calculations based on the business logic, thereby enriching the data that your application handles.

Introducing new attributes calculated from existing ones simplifies application logic and improves performance by reducing the number of queries sent to the database, as expensive computations can be handled in-memory during the data aggregate process.