Skip to main content

Rollup Fields with Dates & Average

  • January 22, 2023
  • 1 reply
  • 0 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!)

 

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

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


Reply