Hans Cornette
03/21/2023, 9:06 PMJakub Sterba
03/21/2023, 9:43 PMselect avg(select Report Time to Control by Records of expenses)
. It basically means that the value will be included into average for each expense record.
It may be also interesting to consider some more complex formula which would calculate weighted average if double counting is an issue.Jakub Sterba
03/21/2023, 9:49 PMselect avg(select avg(Report Time to Control by Report PK, Userprofile)
Hans Cornette
03/22/2023, 8:22 AMHans Cornette
03/24/2023, 1:35 PM