Like 'CalcSums' it would be nice to have a function named 'CalcAverage' which essentially acts like 'CalcSums' only automatically devides the result by the number of records. This would have a performance advantage over the currentmethod which is call CalcSums and Count.
Business Central Team (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