Totaling the average for a field
Hello,
I am creating a time to value metric reporting system. I created a formula that calculates the days in between the student's enrollment date and the date they submitted their first milestone in our course. I would like to find the average (total average days for all students) for all the days in the "Number of Days to Submit Goals Worksheet" Formula field (please see below).
Hi Lydia, if you just need to see the number, you can click at the bottom of your column and it to "Average", which should get you what you're looking for
If you need to actually use the number (e.g. sending it in an email), I'm afraid you'll need to either:
1. Link all of your records to a single record in another table and use a rollup formula there
2. Use a script (Pro plan only)
