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!)
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!)
AVERAGE(values) does not work with date fields.
Can you explain how you want to calculate an average date?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.