Skip to main content

Rollup Fields with Dates & Average

  • January 22, 2023
  • 1 reply
  • 17 views

Forum|alt.badge.img

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

 

This topic has been closed for replies.

1 reply

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • January 22, 2023

AVERAGE(values) does not work with date fields.
Can you explain how you want to calculate an average date?