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!)
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?