We are experiencing issues with clients regarding how aggregated totals are calculated and displayed in the subgrid view. Currently, the total sums are calculated using the base currency (e.g., EUR), even when all the related records are in a different currency (e.g., USD). This leads to confusion and makes it difficult for users to interpret the totals correctly.

We would like to know if there are any future plans to improve this functionality and introduce greater customization options. Specifically, we propose the following enhancements:

• Ability to define where and how the total is displayed on the form so that it is always visible by default when the user opens the record.
• Option to configure the aggregation method used (e.g., SUM, AVERAGE, COUNT).
• Ability to select the currency used for total calculation or aggregation, based on either the record values or user preference.

Our goal is to make the total value immediately visible and intuitive, while still allowing users to adjust calculations through filtering or view configuration if needed.

These improvements would significantly enhance usability for business users working with financial data across multiple currencies.