This resolved once I got the above formula corrected by using BLANK() instead of “” or 0. Thanks again, Elias!

Also, I’m apparently getting the NaN result in summary view because the field I am averaging contains the NaN results, not blanks.

OSU_EHS: IF({Date sent to HR}="",“0”, Thanks, Elias! Here’s how I wound up resolving it: IF({Date sent to HR}="",BLANK(),DATETIME_DIFF({Date sent to HR},{EIR Rcv’d},‘days’))

I’m having the exact same issue but cannot get my IF statement to work: IF({Date sent to HR}="",“0”,DATETIME_DIFF({Date sent to HR},{EIR Rcv’d},‘days’)) If I delete everything before DATETIME the calculation works fine, DATETIME_DIFF({Date sent to HR...