Skip to Content
0
Jun 12, 2019 at 05:45 PM

Avg of DateDiff Formula

90 Views Last edit Jul 22, 2019 at 02:51 PM 2 rev

I created a formula to get the minutes between 2 times using DateDiff:

datediff ("n",{PAT_ENC.AVS_PRINT_TM},{PAT_ENC_HSP.HOSP_DISCH_TIME})

This formula is displaying the correct amount in minutes for each patient but my average is way off. In the example below I have 4 patients where the average should be 64.25 but my report says 40.19. I am using a summary to get the average of the DateDiff field. Not sure why it is not giving me the correct average.

Attachments

rdlhu.png (9.5 kB)