Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 22, 2023 02:56 AM
Hi all,
I am trying to extract the mean/average of a set of dates through roll-ups. I am able to calculate the min or max date through the use of MIN(values) or MAX(values), but AVERAGE(values) returns NaN.
Any suggestions? (thanks in advance!)
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 22, 2023 11:36 AM
AVERAGE(values) does not work with date fields.
Can you explain how you want to calculate an average date?