7
A built-in AutoSum feature for list pages with number columns. Instead of exporting your list to Excel to calculate the sum of a column, a blank row beneath the last row of your list could be used to calculate the sum of a column. For example, if you were on the Shipped Not Invoiced list, you could use the built-in AutoSum feature to calculate the Amount Shipped Not Invoiced ($) column quickly without having to export it to Excel.
Category: General
STATUS DETAILS
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team

Comments

D

This is a good idea! Do you propose other methods of aggregation, such as min/max/average? Should relevant ones work on non-numeric fields, e.g. to get the latest posting date?

It seems you suggest the user must choose manually to calculate sums, but I'd suggest that auto-loading sums could be specified via a page property during development, or perhaps even by customisation.

Lastly I would suggest that the auto-sum row, if present, should be 'pinned' at the bottom of the list, rather than having to scroll all the way down, but I don't know if that is easy to implement from UI/SQL points of view.

Category: General